Multiple $elemMatch expressions for matching array values using $all in MongoDB?

Question

In the answer to a question I found a interesting solution for searching array values using $elemMatch.

If we have the following documents in our collection:

{
    foo : [ { bar : "xy", baz : 1 },
            { bar : "a", baz : 10 } ]
},
{
    foo : [ { bar : "xy", baz : 5 },
            { bar : "b", baz : 50 } ]
}

The following query will match only the first document:

db.test.find({
    foo : { "$all" : [ { "$elemMatch" : { bar : "xy", baz : 1} }, { "$elemMatch" : { bar : "a", baz : 10 } } ] }
});

I tried it with several other examples and it really works. But the official documentation for $all operator doesn't say anything about combining these two queries.

Is this the intended behavior or a bug? Or is this just a problem that the documentation does not cover this use case?

Sid · Accepted Answer · 2012-03-22 15:51:28Z

8

This is the intended behavior. The documentation doesn't cover this use case and we are working on it to make it better. Its difficult, however, to document every possible query combination.

answered Mar 22, 2012 at 15:51

Sid

9646 silver badges7 bronze badges

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

2 Comments

Christian P Over a year ago

Thank for the info. I understand that it's hard to document every combination but it would be very useful to know that some of the operators can be combined.

Ed Knowles Over a year ago

Is there any way to do this yet?

Collectives™ on Stack Overflow

Multiple $elemMatch expressions for matching array values using $all in MongoDB?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related