MongoDB | Query an array of objects based on multiple properties

Question

If this is my data:

{
  owner: 'John',
  pets:[
    {
      name: 'Oscar',
      age: 7,
      type: 'dog'
    },{
      name: 'Oscar II',
      age: 3,
      type: 'dog'
    }
  ]
},{
  owner: 'Sally',
  pets:[
    {
      name: 'Spot',
      age: 7,
      type: 'cat'
    },{
      name: 'Mister Dog',
      age: 3,
      type: 'dog'
    }
  ]
}

How can I build a query to get every owner that has a dog that is 7.

I tried:

Owners.findOne({
  'pets.age': 7,
  'pets.type': 'dog'
});

But this returns every owner who has a pet with an age of 7 OR with a type of dog. In the case of the data above it return both Sally & John. How can I just get John?

Wizard · Accepted Answer · 2014-10-15 01:23:54Z

1

Use $elemMatch to specify all constraints to the same element:

Owners.findOne({
  'pets': {
      '$elemMatch' : {
          'age': 7,
          'type': 'dog'
       }
   }
});

answered Oct 15, 2014 at 1:23

Wizard

4,4311 gold badge17 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

MongoDB | Query an array of objects based on multiple properties

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