Aggregate query result in mongodb

Question

I have collection with documents like this one:

{  
   "_id": 1,
   "people": [  
      {  
         "name": "Bob",
         "age": "15"
      },
      {  
         "name": "Alice",
         "age": "18"
      }
   ]
}

My query is:

db.groups.aggregate({ $match: { "_id": 1 }}, { $project: { "_id": 0, "people.name": 1 } })

This query returns:

{  
   "people": [  
      {  
         "name": "Bob"
      },
      {  
         "name": "Alice"
      }
   ]
}

But I need the result like:

{ "names": [ "Bob", "Alice" ] }

Which parameters should I add to the .aggregate() function?

No need to use $map here... Try this .groups.aggregate({ $match: { "_id": 1 }}, { $project: { "_id": 0, "names": "$people.name" } }) — Ashh
– Ashh, Commented Nov 23, 2018 at 15:16

undefined7887 · Accepted Answer · 2018-11-23 15:23:37Z

1

The solution is:

db.groups.aggregate({ $match: { "_id": 1 }}, { $project: { "_id": 0, "names": "$people.name" } })

edited Nov 23, 2018 at 15:23

answered Nov 23, 2018 at 15:17

undefined7887

1112 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Aggregate query result in mongodb

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