Querying mongodb array fields with more than one condition

Question

Is there a way of querying array fields within documents in mongodb using more than one condition? Example document:

{
    'title': 'A document title',
    'array_element': [
        {
            'some_identifier': 'abcdefg',
            'value': 10
        },
        {
            'some_identifier': 'hijklmnop',
            'value': 5
        },
        {
            ...etc...
        }
    ]
}

I need to query a collection to find the lowest value for a specific identifier, however these values are stored with others in an array. I know I can query the collection to find the document which contains the array element with the lowest value, and which contains the array element which matches an identifier, but I can't be sure that a specific array element will match both of these conditions. Is there a way of doing this efficiently?

Manav Kataria · Accepted Answer · 2015-01-09 00:46:45Z

5

You can use the $elemMatch operator to accomplish this, e.g.

foo.find( { "array_element" : 
             { $elemMatch : { 'some_identifier' : 'abcdefg', 'value' : 8 } } } );

edited Jan 9, 2015 at 0:46

Manav Kataria

5,3705 gold badges26 silver badges26 bronze badges

answered Jan 12, 2012 at 17:32

mnemosyn

46.4k6 gold badges80 silver badges84 bronze badges

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

Collectives™ on Stack Overflow

Querying mongodb array fields with more than one condition

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