Mongodb query from any array position

Question

My schema looks like this:

{
  _id: "myid"
  user: [{"name":"Bob"}, {"name":"Jenny"}]
},
{
  _id: "myid2"
  user: [{"name":"John"}, {"name":"Jenny"}]
},
{
  _id: "myid3"
  user: [{"name":"John"}, {"name":"Bob"}]
}

I want to find all the documents Bob is an user of. He could be any any position in the array. Could this be done?

Thanks.

Abhishek Kumar · Accepted Answer · 2013-06-08 06:45:55Z

4

1) db.test.find({'user.name': 'Bob'})

2) db.test.find({'user' : { $elemMatch : {'name' : 'Bob'}}})

answered Jun 8, 2013 at 6:45

Abhishek Kumar

3,3662 gold badges20 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

Mongodb query from any array position

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