Mongo query to filter out the elements inside an array of objects

Question

There is db structure were the value is array of objects like

{
 key : [
  {
   retrive : false
  },
  {
   retrive : true
  }
 ]
}

And i want to query only the objects were 'retrieve' key is set to true.

All right i found about the $elemMatch operator which does what i want, but it is said that it only retrieves the first document matches but what i want is like multiple $elemMatch — Beast, Jul 31 '13 at 09:45

score 0 · Answer 1 · answered Jul 31 '13 at 09:51

0

  db.collection.find({'key.$.retrive':true},function(err,res){


   });

answered Jul 31 '13 at 09:51

sachin

This nothing is retrieved, the query is like db.collection.find({somekey : someVal, 'key.$.retrive' : true}).pretty(); – Beast Jul 31 '13 at 09:58
replace collection with your collection name. – sachin Jul 31 '13 at 10:11
There is no reason why you need the ``.$.`` in that query, just ``'key.retrive`` should do. – Derick Jul 31 '13 at 12:50
@Derick while accessing field in array we need to specify the '$'. – sachin Aug 01 '13 at 05:17

1 Answers1