Sails.js find multiple database entries by id

javascript node.js mongodb sails.js waterline
prototype picture prototype · Jan 9, 2014 · Viewed 8.5k times · Source

I'm bit new at node.js/sails.js and was wondering (if possible) how to retrieve multiple database entries by searching for their ids - there is something like this mentioned in the MongoDB documentation:

db.inventory.find( { qty: { $in: [ 5, 15 ] } } )

And here is what i've tried:

// users param example: 12341243124, 1231231231, 21312313212
var users = req.param('users').split(',');

User.find({id: { $in: users }}, function (err, response) {
  // do something here
});

Any help would be appreciated! Thanks!

Answer

prototype picture prototype · Jan 9, 2014

Sorry for bothering - as it turns out Waterline supports array parameters - so by changing the code above a bit i got this to work:

User.find()
    .where({id: users})
    .exec(function (err, response) {
        // do stuff
    });

Related questions

How do I update/upsert a document in Mongoose?

Perhaps it's the time, perhaps it's me drowning in sparse documentation and not being able to wrap my head around the concept of updating in Mongoose :) Here's the deal: I have a contact schema and model (shortened properties): var mongoose = …

Read More
Render basic HTML view?

I have a basic node.js app that I am trying to get off the ground using Express framework. I have a views folder where I have an index.html file. But I receive the following error when loading the …

Read More
How do I remove documents using Node.js Mongoose?

FBFriendModel.find({ id: 333 }, function (err, docs) { docs.remove(); //Remove all the documents that match! }); The above doesn't seem to work. The records are still there. Can someone fix?

Read More