Mongodb find in array and select that index

Question

I have a Document setup like this:

Users

{
 _id : '',
 name : '',
 friends : [
   {
     'name' : '',
     'email' : '',
     'age' : ''
   }
 ]
}

I'm trying to select a single friend from within the friends array by email, while only returning that specific object.

Any suggestions how to do this?

Thanks!

Abhishek Kumar · Accepted Answer · 2013-05-09 01:23:05Z

2

db.mytest.find({'friends.email':'abhi2'},{friends : {$elemMatch : {email : 'abhi2'}}}).pretty() 
Or
db.mytest.find({'_id':'a'},{friends : {$elemMatch : {name : 'abhi2'}}}).pretty()

For more details, look this doc : http://docs.mongodb.org/manual/reference/projection/elemMatch/

answered May 9, 2013 at 1:23

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 find in array and select that index

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