NodeJS MongoDB Dynamic Query

Question

I have a NodeJS server running express with a get method at '/api/jobs/'. When called I get some querystring parameters from the url and they make a query against the MongoDB database to get jobs.

Example Url: '/api/jobs/?Groups=1,2&Statuses=3,4'

The MongoDB query i am trying to construct is this:

{ $or: [{"Group.Id" : 1}, {"Group.Id" : 2}], $or: [{"Status.Id": 3}, {"Status.Id": 4}]}

If I run this directly against the database I get the results I need but I can't think of way of constructing the query dynamically in JavaScript. Any attempt i've made gives me an object like this as the $or property can only exist once in a proper JSON object.

{$or : [{"Group.Id" : 1}, {"Group.Id" : 2}]}

Any ideas on how to do this either using JavaScript or thorugh the MongoDB Node API?

Aron · Accepted Answer · 2017-03-28 11:44:50Z

2

Firstly get the query properties, which will be strings:

const groupString = req.query.Groups; // === '1,2'
const statusString = req.query.Statuses; // === '3,4'

Split at the commas and parse as integers:

const groupNums = groupString.split(',').map(parseInt); // === [1, 2]
const statusNums = statusString.split(',').map(parseInt); // === [3, 4]

Then search for any of the group IDs. Your query should look like this:

const query = {"Group.Id": { $in: groupNums }, "Status.Id": { $in: statusNums } };

Do the same for the status IDs.

edited Mar 28, 2017 at 11:44

answered Mar 28, 2017 at 11:25

Aron

9,3187 gold badges37 silver badges60 bronze badges

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

1 Comment

Jareth Over a year ago

That did it! Thanks

marc_s · Accepted Answer · 2021-05-09 11:13:05Z

0

You can use this

app.get('/', function(req, res, next) {
var queryArry = [];
for (var i in req.query) {
    var sampleObject = { value: [] };
    sampleObject.name = i;
    req.query[i].split(',').forEach(function(each) {
        sampleObject.value.push(parseInt(each));
    })
    queryArry.push(sampleObject);
 }
  var mongoquery = {};

  for (var i in queryArry) {

     mongoquery[queryArry[i].name] = queryArry[i].value;

 }
  res.send(mongoquery);
 });

But in this case, you have to send same name field of MongoDB and query parameter key. If you did this it is fully dynamic query builder.

edited May 9, 2021 at 11:13

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Mar 28, 2017 at 12:07

Rahul Dey

1071 silver badge11 bronze badges

Collectives™ on Stack Overflow

NodeJS MongoDB Dynamic Query

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related