mongodb/mongoose findMany - find all documents with IDs listed in array

Question

I have an array of _ids and I want to get all docs accordingly, what's the best way to do it ?

Something like ...

// doesn't work ... of course ...  model.find({     '_id' : [         '4ed3ede8844f0f351100000c',         '4ed3f117a844e0471100000d',          '4ed3f18132f50c491100000e'     ] }, function(err, docs){     console.log(docs); }); 

The array might contain hundreds of _ids.

Answer 1

The find function in mongoose is a full query to mongoDB. This means you can use the handy mongoDB $in clause, which works just like the SQL version of the same.

model.find({     '_id': { $in: [         mongoose.Types.ObjectId('4ed3ede8844f0f351100000c'),         mongoose.Types.ObjectId('4ed3f117a844e0471100000d'),          mongoose.Types.ObjectId('4ed3f18132f50c491100000e')     ]} }, function(err, docs){      console.log(docs); }); 

This method will work well even for arrays containing tens of thousands of ids. (See Efficiently determine the owner of a record)

I would recommend that anybody working with mongoDB read through the Advanced Queries section of the excellent Official mongoDB Docs

Answer 2

Ids is the array of object ids:

const ids =  [     '4ed3ede8844f0f351100000c',     '4ed3f117a844e0471100000d',      '4ed3f18132f50c491100000e', ]; 

Using Mongoose with callback:

Model.find().where('_id').in(ids).exec((err, records) => {}); 

Using Mongoose with async function:

const records = await Model.find().where('_id').in(ids).exec(); 

Or more concise:

const records = await Model.find({ '_id': { $in: ids } }); 

Don't forget to change Model with your actual model.