mongodb queryto find data based on nested data

Question

I want to find a collection from below, with email condition: Below is my collections:

{
"_id" : ObjectId("59265694165bc936e998e314"),
"registrationToken" : null,
"temporaryInvitationId" : null,
"local" : {
    "password" : "$2a$10$xkNapVoNInR.FcGOqV4CjKYKV2hCWBzYIoufrFf2",
    "email" : "abc@gmail.com"
},
"__v" : 0,
"passwordResetToken" : null,
"profile" : {
    "referralId" : "r18YCPsgW",
    "_id" : ObjectId("597b7403aca04d1968823668"),
    "dietaryPreferences" : [ ],
    "referrerId" : "By2b4eKUb",
    "percentCommission" : 5
},
"lastLogin" : ISODate("2017-12-21T17:49:46.434Z")
},
{
"_id" : ObjectId("59265694165bc936e998e323"),
"registrationToken" : null,
"temporaryInvitationId" : null,
"local" : {
    "password" : "$2a$10$xkNapVoNInR.FcGOqV4CjKYKV2hCWBzYIoufrFf2",
    "email" : "xyz@gmail.com"
},
"__v" : 0,
"passwordResetToken" : null,
"profile" : {
    "referralId" : "r18YCPsgW",
    "_id" : ObjectId("597b7403aca04d1968823669"),
    "dietaryPreferences" : [ ],
    "referrerId" : "By2b4eKUb",
    "percentCommission" : 5
},
"lastLogin" : ISODate("2017-12-21T17:49:46.434Z")

}

I am using below query:

db.users.find( { "local": { email: "abc@hotmail.com" } } ).pretty()

But not able to get result. Please suggest what to do for get result if email is equal to 'abc@gmail.com'.

Thanks in advance

score 1 · Accepted Answer · answered Aug 01 '18 at 12:21

1

Simply use dot:

db.users.find({"local.email": "abc@hotmail.com"}).pretty()

answered Aug 01 '18 at 12:21

wowkin2

5,895
5
23
66

Thanks, @wowkin2! it worked :) – rohit13807 Aug 01 '18 at 12:23
@rohit13807 please mark my answer as "accepted", so everybody will know that it is resolved :) – wowkin2 Aug 01 '18 at 12:26
1

I can do only after 11 minute, its restriction from site. Will do when time finish. Cheers! – rohit13807 Aug 01 '18 at 12:28
@rohit13807 you marked not my answer by accident, please have a look :) – wowkin2 Aug 03 '18 at 13:29

score 1 · Answer 2 · answered Aug 01 '18 at 12:24

1

You can use this query

db.col.find({"local.email" : "abc@gmail.com"})

answered Aug 01 '18 at 12:24

Senthur Deva

737
4
12

mongodb queryto find data based on nested data

2 Answers2