Mongo how to get specific array field with value or object value

Question

So I have these mongo fields

    "username" : "aaaaaa",
    "emails" : [
               {
                   "address" : "[email protected]",
                   "verified" : false
               }
               ],
    "profile" : {
                   "firstname" : "a",
                   "lastname" : "a"
                }

I can do

db.users.find({username:'aaaaaa'});

My question is, how about if I want to use the email address or profile's firstname?

It seems like this

db.users.find({email:{firstname:'[email protected]'}});

but it doesn't work. and I can't use

email['address']:'[email protected]'

or even

profile:{firstname:'a'} // profile.firstname:'a';

How can I get only their value?

Try db.users.find({'email.firstname':'[email protected]'});

Andrew
– Andrew

2013-12-26 10:55:19 +00:00
Commented Dec 26, 2013 at 10:55 — Andrew
– Andrew, Commented Dec 26, 2013 at 10:55

4J41 · Accepted Answer · 2013-12-26 10:56:43Z

3

If you want to use the email address to query then,

db.users.find({'emails.address':'[email protected]'});

If you want to use the profile's firstname to query,

db.users.find({'profile.firstname':'a'});

answered Dec 26, 2013 at 10:56

4J41

5,1051 gold badge31 silver badges43 bronze badges

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

1 Comment

BenjaminRH Over a year ago

Actually, you'll want find({'emails.0.address': 'foo'}); -- note the 0 between emails and address. This is because emails is an array.

Collectives™ on Stack Overflow

Mongo how to get specific array field with value or object value

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