How can I find multiple records of collection by mongo objectID

Question

I am trying this query but its return only one record.

db.getCollection('lists').find({_id:ObjectId("5b51c7cf307331187c5429bd"),_id:ObjectId("5b507c322fa5767930f0a09f")})

I also tried this but it returns nothing.

db.getCollection('lists').find({_id:ObjectId("5b51c7cf307331187c5429bd")},{_id:ObjectId("5b507c322fa5767930f0a09f")})

Possible duplicate of [Mongo, find through list of ids](https://stackoverflow.com/questions/15102532/mongo-find-through-list-of-ids) — Ahmed Yousif, Jul 25 '18 at 06:06

score 1 · Accepted Answer · answered Jul 25 '18 at 06:04

There are multiple ways to find multiple records based on criteria.

db.getCollection('lists').find({_id: {"$in" : [ObjectId("5b51c7cf307331187c5429bd"), ObjectId("5b51c7cf307331187c5429bd")]}})

db.getCollection('lists').find({"$or" : [{ _id : ObjectId("5b51c7cf307331187c5429bd")}, { _id: ObjectId("5b51c7cf307331187c5429bd")}]})

score 1 · Answer 2 · answered Jul 25 '18 at 06:12

1

for the multiple you should use $in operator of mongodb you can take the reference from mongodb dos

answered Jul 25 '18 at 06:12

Vipul Pandey

2 Answers2