Filter like API using query string in nodeJS and mongoDB

Question

I'm trying to write a simple API using filter to get users from database. I want to filter this data by given specific params, which are optional:

How to make it flexible to get data from database by querying API with no params, single param and multiple params ?

Controller:-

Method-1

const articles = await userTable.find({
    '$or': [{
        'name': req.query.name
     },
     {
       'address': req.query.address
     },
     {
       'address': req.query.address,
       'name': req.query.name
     }]
  });

When I hit by single params it give correct response but when hit by multiple params http://localhost:4000/api/filter?name=abhishek&address=tejaji it give wrong response but i want only that row which contains name abhishek and adress tejaji

Method-2

const articles = await userTable.find({
    name:req.query.name,address:req.query.address,
    $or: [ { name:req.query.name }, {address:req.query.address } ]
});

When i hit by single params it give 0 response but when hit by multiple params http://localhost:4000/api/filter?name=abhishek&address=tejaji it give correct response but i want result from single params also

Method-3

const articles = await userTable.find({
  'usertables': {
        $elemMatch: {
          'name': req.query.name,
          'address': req.query.address
        }
    }
});

When i hit by single params http://localhost:4000/api/filter?name=abhishek or multiple http://localhost:4000/api/filter?name=abhishek&address=tejaji it always give all rows from table, which is wrong.

Route:-

router.get("/filter", userController.filterMethod);

lpizzinidev · Accepted Answer · 2021-12-24 08:12:52Z

4

Try to use a filter object and add keys to it based on what params are present:

const { name, address } = req.query;
const filter = {}
if (name) {
    filter.name = name 
}
if (address) {
    filter.address = address
}
const articles = await userTable.find(filter);

answered Dec 24, 2021 at 8:12

lpizzinidev

13.3k2 gold badges15 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Abhi Over a year ago

You are a genius sir, thank you so much. but i want to know apart from this solution, is there any other way ?

Collectives™ on Stack Overflow

Filter like API using query string in nodeJS and mongoDB

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related