Query a double nested array with multiple filters

Question

This is my data:

{
    "_id": 1,
    "items": [
        [{"name": "a"}, {"size": 2}, {"color": "red"}],
        [{"name": "b"}, {"size": 4}, {"color": "blue"}],
        [{"name": "c"}, {"size": 6}, {"color": "pink"}]
    ]    
},
{
    "_id": 2,
    "items": [
        [{"name": "a"}, {"size": 3}, {"color": "black"}],
        [{"name": "e"}, {"size": 6}, {"color": "blue"}],
        [{"name": "g"}, {"size": 9}, {"color": "pink"}]
    ]    
}

And I need to do something like this:

db.foo.find({items.name: "a", items.color: "red"})

It's not working

Possible duplicate of MongoDB Query double nested documents in array — LatentDenis
– LatentDenis, Commented Apr 27, 2017 at 20:37
try something like db.foo.find({ items: {$all: ["name": "a"], ["color": "red"]}}); Let me know if that works — LatentDenis
– LatentDenis, Commented Apr 27, 2017 at 21:12

georgbc · Accepted Answer · 2017-04-28 02:37:08Z

0

For this, you could make use of the $elemMatch keyword.

db.foo.find({items: {$elemMatch: {name: "a", color: "red"} } });

That should allow to match on multiple fields of a document within an array.

answered Apr 28, 2017 at 2:37

georgbc

567 bronze badges

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

Comments

Marcelo · Accepted Answer · 2017-04-28 13:51:14Z

0

I found this solution:

db.foo.find({ 
    items: {
        $elemMatch: {
            $all: [
                {$elemMatch: {"name": "a"}},
                {$elemMatch: {"color": "red"}}
               ]
         }
    }
});

Thanks guys!!

answered Apr 28, 2017 at 13:51

Marcelo

111 bronze badge

Collectives™ on Stack Overflow

Query a double nested array with multiple filters

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related