MongoDB - filter by several array elements

Question

Suppose I have documents like this:

{
    "_id", "1",
    "myarray": [
        {
           "address": "abc",
           "role": "input",
        }
        {
           "address": "def",
           "role": "output",
        }
    ]
},
{
    "_id", "2",
    "myarray": [
        {
           "address": "xyz",
           "role": "input",
        }
        {
           "address": "abc",
           "role": "output",
        }
    ]
}

I want to return documents where myarray.address is abc and myarray.role is output, but not the documents where exists myarray.address='abc' and exists myarray.role='output', but the documents where exists element of myarray array:

address: "abc",
role: "output"

Using the example above, I want only the document with _id=2.

Ashh · Accepted Answer · 2019-03-16 17:17:51Z

2

You can use $elemMatch query operator to match multiple fields inside an array

db.collection.find({ myArray: { $elemMatch: { address: 'abc', role: 'output' }}})

edited Mar 16, 2019 at 17:17

answered Mar 16, 2019 at 16:18

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

1 Comment

DimaA6_ABC Over a year ago

So simple :) My position at MongoDB learning curve seems 1 step from the beginning :)

Collectives™ on Stack Overflow

MongoDB - filter by several array elements

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related