Query with parameter which is an array in MongoDB [duplicate]

Question

I have an array like this :

 Array<int> arr = [1,3,98,12,...]

and I want to get all documents having Id which belongs to that array

 db.collection.find({"key": arr})

It would be crazy to use

  for (int i=1; i<= arr.length(); i++)
  {
    db.collection.find({"key": i})
  }

Instead, please help me if you know an effective way. Thanks !

Since you tagged this as Java, stackoverflow.com/questions/11650970/… seems like a reasonable match using $in. — WiredPrairie
– WiredPrairie, Commented Dec 29, 2013 at 19:52

4J41 · Accepted Answer · 2013-12-29 19:23:37Z

2

Use the $in operator.

db.collection.find({"key" : {"$in" : arr} })

The above query returns any document if its key is in arr.

answered Dec 29, 2013 at 19:23

4J41

5,1051 gold badge31 silver badges43 bronze badges

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

Comments

Matt · Accepted Answer · 2013-12-29 19:23:23Z

2

Try the $in operator as described in the documentation. Something like this should do the trick:

db.collection.find({ "key": { "$in" : arr} })

answered Dec 29, 2013 at 19:23

Matt

17.7k7 gold badges60 silver badges72 bronze badges