Find documents with array of string ID's in MongoDB

Question

I have an string array of id's that i'd like to use with the find function.

db.companies.find( { _id : { $in : arr} });

arr looks something like this,

[ '563a2c60b511b7ff2c61e938', '563a2c60b511b7ff2c61e8b7' ];

I see from the documentation that ObjectID() doesn't accept arrays. How can I search for a list of documents with this array? Will I have to recreate the array so that all elements are ObjectID's?

What is the output when you run that query?

TbWill4321
– TbWill4321

2015-12-15 22:31:22 +00:00
Commented Dec 15, 2015 at 22:31 — TbWill4321
– TbWill4321, Commented Dec 15, 2015 at 22:31

dreyescat · Accepted Answer · 2015-12-15 22:39:28Z

7

One option is to use the map function to get the list of ObjectId's from the list of string ids:

arr.map(function (id) {
  return ObjectId(id);
})

Plugged into your query:

db.companies.find({_id: { $in: arr.map(function (id) {return ObjectId(id);})}})

answered Dec 15, 2015 at 22:39

dreyescat

13.9k5 gold badges52 silver badges38 bronze badges

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

Collectives™ on Stack Overflow

Find documents with array of string ID's in MongoDB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related