How to query two fields on same nested document

Question

How can I get only second document, that have child {"name": "Harry", "age": 20}.

I tried query db.items.find({"children.name": "Harry", "children.age": 20}), but it searches for single field match instead of both in children

[
  {
    "children": [
      {
        "name": "Harry",
        "age": 50
      },
      {
        "name": "Dmitry",
        "age": 20
      }
    ]
  },
  {
    "children": [
      {
        "name": "Harry",
        "age": 20
      }
    ]
  }
]

use [$elemMatch](https://docs.mongodb.com/manual/reference/operator/query/elemMatch/) to match array elements. — turivishal, May 31 '21 at 14:19
@turivishal Add an answer please, so I can select it as right one — AidOnline01, May 31 '21 at 14:37
this is common question and lot of similar questions so I am voting to close this question. — turivishal, May 31 '21 at 14:40

score 0 · Answer 1 · answered May 31 '21 at 19:53

db.items.aggregate([
    {
        $match:
        {
            "children":
            {
                $elemMatch:
                {
                    "name": "Harry",
                    "age": 20
                }
            }
        }
    }
])

How to query two fields on same nested document

1 Answers1