MongoDB query nested document fields simultaneously

Question

Having document in collection test as follow:

{a:2, list:[{lang:"en", value:"Mother"}, {lang:"de", value:"Mutter"}] }

When I query:

db.test.find({"list.lang":"de", "list.value": "Mother" })

I'm expecting to get nothing, but on reason that exist document with 2 nested entries that satisfies total condition MongoDB resolves {a:2}

How to fix query to retrieve only documents where both inner fields satisfies to specified condition simultaneously?

I can think of a query that uses `$all` as `db.test.find({ "list": { "$all": [{"lang":"de", "value": "Mother" }] } })` — chridam, Sep 19 '16 at 16:35
What about [$elemMatch](https://docs.mongodb.com/manual/reference/operator/query/elemMatch/) `db.test.find({ "list": { "$elemMatch": {"lang":"de", "value": "Mother" } } })` — Ali Dehghani, Sep 19 '16 at 16:44

score 4 · Accepted Answer · edited Sep 20 '16 at 08:54

4

db.test.find({ "list": { "$elemMatch": {"lang":"de", "value": "Mother" } } })

Using $all:

db.test.find({ "list": { "$all": [{"lang":"de", "value": "Mother" }] } })

edited Sep 20 '16 at 08:54

Ali Dehghani

answered Sep 19 '16 at 17:27

4J41

Thank you for the answer. What of this cases use the indexes? – Dewfy Sep 20 '16 at 07:30

1 Answers1