Database
[{"_id":1,"locations":[{"code":{"defaultValue":"IL1"},"locationSpecifications":[{"code":{"defaultValue":"LS1"},"minimumCount":{"defaultValue":"0"}},{"code":{"defaultValue":"LS2"},"minimumCount":{"defaultValue":"1"}}]}]}]
Query
db.collection.find({"_id":1,locations:{"$elemMatch":{"code.defaultValue":"IL1",locationSpecifications:{"$elemMatch":{"code.defaultValue":"LS1"}}}}})