MongoDB - Find only documents where their arrays contains the query's array

Question

How to get all documents with a find query where the queried array fields are exists in the document?

{
    name: 'test1',
    "array": [
        {
            "name": "100",
            "subArray": [
                "arr1"
            ]
        },
        {
            "name": "200",
            "subArray": [
                "arr2",
                "arr3"
            ]
        }
    ]
}

If i use this query in the find({}) it gives back not only the good results:

$and: [
  {'array.name': '100'}, {'array.subArray': 'arr1'},
  {'array.name': '200'}, {'array.subArray': 'arr2'}
]

Sede · Accepted Answer · 2016-03-15 16:22:59Z

1

You need to use the $elemMatch operator. Your query should look like this:

$and: [
  { array: { $elemMatch: { name: '100', subArray: 'arr1' } } },
  { array: { $elemMatch: { name: '200', subArray: 'arr1' } } }
]

edited Mar 15, 2016 at 16:22

Sede

61.5k20 gold badges158 silver badges162 bronze badges

answered Mar 15, 2016 at 15:19

Schore

9156 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

MongoDB - Find only documents where their arrays contains the query's array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related