CODEWITHSUNDEEP
mongodbnested-documents
Dewfy
Dewfy

Reputation: 23624

MongoDB query nested document fields simultaneously

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?

Upvotes: 2

Views: 928

Answers (1)

4J41
4J41

Reputation: 5095

Using $elemMatch:

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

Using $all:

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

Upvotes: 4

Related Questions