MongoDB search in array of sub documents

Question

I have this data in mongodb. my query is not matching this record.

/* 1 */
{
    "_id" : ObjectId("5a60fd777f57eea025f0521d"),
    "groupname" : "my Users",
    "memberes" : [ 
        {
            "CN" : "john, miller",
            "employeeNumber" : "865",

        }, 
        {
            "CN" : "sunil, kumar",
            "employeeNumber" : "456",

        }
    ]
}

query

db.collection.find( { "memberes": { "employeeNumber" : "456"} } )

Can help me to correct this query?

Thanks SR

Looks at this https://stackoverflow.com/questions/48083603/mongodb-c-sharp-complex-query/48083997#48083997 It's C# but you can use the same approach for this — RICKY KUMAR, Jan 18 '18 at 23:25
Possible duplicate of [How to query nested objects?](https://stackoverflow.com/questions/16002659/how-to-query-nested-objects) — s7vr, Jan 18 '18 at 23:33

Syed Arefinul Haque · Accepted Answer · 2018-01-18T23:37:33.817

0

Look at this answer and the documentation here

The corrected query according to these materials would be:

db.collection.find({ "memberes.employeeNumber" : "456"})

edited Jan 18 '18 at 23:37

answered Jan 18 '18 at 23:31

Syed Arefinul Haque

1,123
2
14
38

MongoDB search in array of sub documents

1 Answers1