Sort array values after grouping - mongodb

Question

I have grouped data with favourites, and I have pushed into array.I want to sort the array with object key for example name,email,or age.

 {
                        $group:
                        {
                            _id: "$favourite",
                            favourite: { $first: "$favourite" },
                            data: {
                                $push: {
                                    "name": "$name",
                                    "email": "$email",
                                    "age": "$age"
                                }
                            }
                        }
                    }

I tried with this below code, but its not working.

  { "$sort": { "data.name": 1 } }

How to resolve this?

Ashh · Accepted Answer · 2019-06-07 18:50:00Z

8

Use $sort before $group stage

db.collection.aggregate([
  { "$sort": { "name": 1 }},
  { "$group": {
    "_id": "$favourite",
    "favourite": { "$first": "$favourite" },
    "data": {
      "$push": {
        "name": "$name",
        "email": "$email",
        "age": "$age"
      }
    }
  }}
])

edited Jun 7, 2019 at 18:50

answered Jul 25, 2018 at 16:02

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

Collectives™ on Stack Overflow

Sort array values after grouping - 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