MongoDB - Query document by same field from multiple objects in array

Question

I have a document that looks like this:

{
  "_id" : "AouRpb5g2WR9sZe5z",
  "participants" : [ 
    {
        "user" : "CYvApwRFADveqBqEY",
        "unread" : false
    }, 
    {
        "user" : "sgoinZkaHbqth8nPr",
        "unread" : false
    }
   ],
 "createdAt" : ISODate("2016-07-23T04:06:53.748Z")
}

I need to be able to find the document that has both users 'CYvApwRFADveqBqEY' and 'sgoinZkaHbqth8nPr'. I was able to find all documents with one of the users with elemMatch, but couldn't figure it out for both, or if that's even the correct way.

Bertrand Martel · Accepted Answer · 2016-07-23 19:33:54Z

2

With a find query with an $all, you can do :

db.device.find({
  "participants.user": {
    $all: ["CYvApwRFADveqBqEY", "sgoinZkaHbqth8nPr"]
  }
});

From the doc of $all :

The $all operator selects the documents where the value of a field is an >array that contains all the specified elements.

edited Jul 23, 2016 at 19:33

answered Jul 23, 2016 at 19:25

Bertrand Martel

46k17 gold badges156 silver badges170 bronze badges

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

1 Comment

gkrizek Over a year ago

Thank you!! Works perfectly.

Collectives™ on Stack Overflow

MongoDB - Query document by same field from multiple objects in array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related