MongoDB - Project only the matching element in an array

Question

How could I get one element from array from Mongo document with following structure:

{
 array : [ 
           {type: 'cat', name: 'George'}
           {type: 'cat', name: 'Mary'} 
           {type: 'dog', name: 'Steve'} 
           {type: 'dog', name: 'Anna'}  

         ]
}

For example I need to get Steve, in this case result must looks so:

{
 array : [ 
           {type: 'dog', name: 'Steve'}
 ] 
}

or so: {type: 'dog', name: 'Steve'}

I know how make it while publishing but I need to make it on client side where whole array is available, I could return this value from array using forEach, but I'm searching more elegant way (using Mongo query).

Possible duplicate of Retrieve only the queried element in an object array in MongoDB collection — Sede
– Sede, Commented Dec 20, 2015 at 20:52

BatScream · Accepted Answer · 2015-12-20 20:58:38Z

12

Use the positional operator($) to project only the first matching sub document.

db.t.find({"array":{"type":"dog", "name":"Steve"}},{"array.$":1})

Using meteor, you would have to stick to aggregation, since the positional operator does not work:

db.t.aggregate([
{$match:{"array.type":"dog","array.name":"Steve"}},
{$unwind:"$array"},
{$match:{"array.type":"dog","array.name":"Steve"}}
])

edited Dec 20, 2015 at 20:58

answered Dec 20, 2015 at 20:32

BatScream

19.7k4 gold badges54 silver badges68 bronze badges

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

4 Comments

expeerd Over a year ago

On server side query that looks like yours really returns array with matched elements, but on client side (minimongo) they returns whole array.

BatScream Over a year ago

Not sure if the issue - github.com/meteor/meteor/issues/153 is still open. If it is you have to iterate through all your sub documents as in - stackoverflow.com/questions/27951102/…

BatScream Over a year ago

@expeerd - you may need to stick to aggregating the result, in minimongo. See my updated answer.

expeerd Over a year ago

Sorry about late reply. Aggregate works for me, but it has only server side implementation and is non reactive.

Collectives™ on Stack Overflow

MongoDB - Project only the matching element in an array

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related