MongoDB Query double nested documents in array

Question

I was wondering how I can query from an embedded document inside an array. I have following structure:

{ "targetId" : 2, "metaData" : [ {     "key" : "id",     "value" : 1 },     {     "key" :        "name",     "value" : "Parisa" },     {     "key" : "img",     "value" : {     "imgid" : 1,         "imgName" : "img1" } } ]

I could search simple key-values like key = id and value =1, but I could not search based on the values with embedded document e.g. key="img"

I tried following query but it does not work:

db.test.find({"metaData":{$elemMatch:{"key":"img", "value":{"imgid":1}}}})

Could you please help me!

nickk_can · Accepted Answer · 2014-08-19 21:27:30Z

1

I think the "value" part of your query is a little off. You need to put the document element in the criteria:

b.test.find({"metaData":{$elemMatch:{"key":"img", "value.imgid":1}}})

answered Aug 19, 2014 at 21:27

nickk_can

3553 silver badges11 bronze badges

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

1 Comment

user3376020 Over a year ago

unfortunately, it does not return any document!

Collectives™ on Stack Overflow

MongoDB Query double nested documents in array

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