Mongo DB find() query for nested document

Question

I am new with MongoDB. I want to retrieve document based on condition on nested document. Example :

db.user.insert([
{name:"abc",uid:"abc.b",pass:"abc3",follows:500,posts:78},
{name:"xyz",uid:"xyz.r",pass:"xyz4",follows:600,posts:78},
{name:"pqr",uid:"pqr.s",pass:"pqr5",follows:600,posts:78,
      comments:[{
                  uid:"abc.b",msg:"great"},{uid:"xyz.r",msg:"awesome"}
               ]}
])

Here, how to retrieve documents based upon condition equivalent to RDBMS as :

 select * where comments.user="abc";

By which I can get users commented by "abc".

Thanks in Advance.

chridam · Accepted Answer · 2015-04-03 22:09:14Z

2

Use the dot notation to access the embedded array element in your query object. For example, the following will query for documents in the user collection on the uid field of the comments array with value "abc.d":

db.user.find({"comments.uid": "abc.b"});

answered Apr 3, 2015 at 22:09

chridam

104k26 gold badges246 silver badges243 bronze badges

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

Comments

Satish Kumar · Accepted Answer · 2015-04-03 20:18:30Z

-1

db.user.find({"comments.user"="abc"})

answered Apr 3, 2015 at 20:18

Satish Kumar

1

1 Comment

Tanmay Baranwal Over a year ago

This one is wrong though. '=' has nothing to do with conditional queries in MongoDB

Collectives™ on Stack Overflow

Mongo DB find() query for nested document

2 Answers 2

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Related