MongoDB: How to find _id $in array of objects?

Question

I have a "group" collection which groups documents from another "item" collection. The group collection is simply an array of ObjectId's from the item collection, however I want to make the objects in the group array more complex and still be able to use the $in and $nin operators.

How can I use $in when changing the value used with the $in operator to an object instead of only an ObjectId?

// current group document
{
  _id: ObjectId(...),
  items: [
    ObjectId(...),
    ObjectId(...)
  ]
}
// current item find query
db.item.find({ _id : { $in: group.items } }

I would like to change the group document to look like the following

{
  _id: ObjectId(...),
  items: [
     { _id : ObjectId(...), name: '...' },
     { _id : ObjectId(...), name: '...' }
  ]
}

Wake · Accepted Answer · 2016-08-24 16:51:25Z

3

Transform your group array to a simple array of ids to use for your find():

// revised item find logic
var itemGroupItemIds = group.items.map(function(item){
    return item._id
});
db.item.find({ _id : { $in: itemGroupItemIds } });

answered Aug 24, 2016 at 16:51

Wake

1,69610 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

MongoDB: How to find _id $in array of objects?

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