MongoDB – Find all docs by array of ids within an array of objects

Question

I want to find any entries in my collection 'groups' where the id of the object in the array 'games' is in an array of ids.

The logic in JS:

for (const game in games) {
  return game.find(field => field.id.indexOf(arrayOfIds));
}

And my idea of logic for mongoose:

db.groups.find({ "games.id": { $in: ["5a945...", "1701fa..."] } });

Could you edit your question and paste sample documents and expected output ? — mickl
– mickl, Commented May 7, 2018 at 16:10

Ashh · Accepted Answer · 2018-05-08 02:18:02Z

1

you should use $elemMatch to match the array

    db.collection.find({
  "games": {
    $elemMatch: {
      id: {
        $in: ["5a945...", "1701fa..."]
      }
    }
  }
})

answered May 8, 2018 at 2:18

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

1 Comment

That worked! But only when I delete the ObjectId notation from the strings in the array...