MongoDB match a subdocument inside array (not positional reference)

Question

My MongoDB has a key-value pair structure, inside my document has a data field which is an array that contains many subdocuments of two fields: name and value.

How do I search for a subdocument e.g ( {"name":"position", "value":"manager"}) and also multiple (e.g. {"name":"age", "value" : {$ge: 30}})

EDIT: I am not looking for a specific subdocument as I mentioned in title (not positional reference), rather, I want to retrieve the entire document but I need it to match the two subdocuments exactly.

Possible duplicate of Retrieve only the queried element in an object array in MongoDB collection — s7vr
– s7vr, Commented Apr 27, 2017 at 13:53
No, I don't want to find a specific subdocument, I want to retrieve the entire record. But my question is how do I query using a subdocument in an array. — drhanlau
– drhanlau, Commented Apr 27, 2017 at 13:56
Understood. Use $elemMatch query variant. docs.mongodb.com/manual/reference/operator/query/elemMatch & docs.mongodb.com/manual/tutorial/query-array-of-documents — s7vr
– s7vr, Commented Apr 27, 2017 at 13:57
Thanks @Veeram, is there any example if I want to query multiple elemMatch, is it using $and operator? — drhanlau
– drhanlau, Commented Apr 27, 2017 at 14:03
Np. Here you go. docs.mongodb.com/manual/reference/operator/query/all/… — s7vr
– s7vr, Commented Apr 27, 2017 at 14:05

Community · Accepted Answer · 2017-05-23 12:09:56Z

1

Here are 2 queries to find the following record:

{ 
    "_id" : ObjectId("sometobjectID"), 
    "data" : [
        {
            "name" : "position", 
            "value" : "manager"
        }
    ]
}

// Both value and name (in the same record):
db.demo.find({$elemMatch: {"value": "manager", "name":"position"}})


// Both value and name (not necessarily in the same record):
db.demo.find({"data.value": "manager", "data.name":"position"})


// Just value:    
db.demo.find({"data.value": "manager"})

Note how the . is used, this works for all subdocuments, even if they are in an array.

You can use any operator you like here, including $gte

edit

$elemMatch added to answer because of @Veeram's response

This answer explains the difference between $elemMatch and .

edited May 23, 2017 at 12:09

CommunityBot

11 silver badge

answered Apr 27, 2017 at 14:15

Dan Green-Leipciger

3,9621 gold badge22 silver badges32 bronze badges

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

1 Comment

Dan Green-Leipciger Over a year ago

Awesome. In that case, @cherhan would you mind up voting the answer. ?

Collectives™ on Stack Overflow

MongoDB match a subdocument inside array (not positional reference)

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related