Mongodb querying from part of object in array

Question

Here's the sample document I'm trying to query

{
   "_id":"asdf0-002f-42d6-b111-ade91df09249",
   "user":[
      {
         "_id":"14bfgdsfg0-3708-46ee-8164-7ee1d029a507",
         "n":"aaa"
      },
      {
         "_id":"aasdfa89-5cfe-4861-8a9a-f77428158ca9",
         "n":"bbb"
      }
   ]
}

The document has 2 user references and contains the user _id and other misc information. I have the 2 user ids and am trying to get this document via only the user ids. I also don't know the order of the 2 ids. Is this a possible query?

col.findOne({
   user:{
      $all:[
         {
            _id:"14bfgdsfg0-3708-46ee-8164-7ee1d029a507"
         },
         {
            _id:"aasdfa89-5cfe-4861-8a9a-f77428158ca9"
         }
      ]
   }
})

^^ Something that I've tried that doesn't work.

Community · Accepted Answer · 2017-05-23 11:56:30Z

2

You are close with your $all attempt.

col.findOne({
   "user._id":{
       $all : [ "14bfgdsfg0-3708-46ee-8164-7ee1d029a507", 
            "aasdfa89-5cfe-4861-8a9a-f77428158ca9" ]

   }
}

You can query a sub-document by wrapping it quotes. From there $all works against the values you are looking for.

Mongodb find a document with all subdocuments satisfying a condition shows a variation on this type of query.

edited May 23, 2017 at 11:56

CommunityBot

11 silver badge

answered Jun 26, 2013 at 16:54

Joe Doyle

6,3833 gold badges45 silver badges45 bronze badges

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

Comments

daveh · Accepted Answer · 2013-06-26 06:37:39Z

1

ElemMatch should do the trick.

col.findOne({user:{$elemMatch:{"_id":"14bfgdsfg0-3708-46ee-8164-7ee1d029a507", "_id":"aasdfa89-5cfe-4861-8a9a-f77428158ca9" }}})

answered Jun 26, 2013 at 6:37

daveh

3,7061 gold badge23 silver badges14 bronze badges

1 Comment

Harry Over a year ago

I actually need to have both of these ids in the document. This matches other documents as well. This document is the chat document for these 2 users so I need both of them.

Collectives™ on Stack Overflow

Mongodb querying from part of object in array

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related