In mongodb,How to use aggregation to get the correspondence between fields

user_18437859 0
Viewed 20

I have an example collection of documents:

{name:"Danny", age:20, gender: 0}
{name:"Jordan", age:15, gender: 1}
{name:"Li Mei", age:20, gender: 1}
{name:"Soojin", age:17, gender: 0}
{name:"Zhang Ming", age:22, gender: 1}

I want to get the following results by grouping according to gender

{
  "Test field":[{name:"Danny", age: 20}, {name:"Soojin", age: 17}]
}
{
  "Test field":[{name:"Jordan", age: 15}, {name:"Li Mei", age: 20}, {name: "Zhang Ming", age: 22}]
}

What query can accomplish this?

mongodb-query mongodb
1 Answers

Try this:

db.collection.aggregate([
  {
    "$group": {
      "_id": "$gender",
      "Test Field": {
        "$push": {
          age: "$age",
          name: "$name"
        }
      }
    }
  },
  {
    "$project": {
      _id: 0
    }
  }
])

See it working here.

user_123681540
Related