Sort array of objects, using values inside each object (aggregation framework)

Question

Suppose I have these documents:

[
  {
    '_id': 1,
    'roles': [
      {
        'k': 'free',
        'v': 1
      },
      {
        'k': 'pro',
        'v': 5
      },
      {
        'k': 'free',
        'v': 2
      }
    ]
  },
  {
    '_id': 2,
    'roles': [
      {
        'k': 'pro',
        'v': 1
      },
      {
        'k': 'free',
        'v': 3
      },
      {
        'k': 'free',
        'v': 2
      }
    ]
  }
]

So for every _id, we have a array of documents called roles.
I need to sort inside the array roles, using the v field.

Expected output:

[
  {
    '_id': 1,
    'roles': [
      {
        'k': 'free',
        'v': 1
      },
      {
        'k': 'free',
        'v': 2
      }
      {
        'k': 'pro',
        'v': 5
      }
    ]
  },
  {
    '_id': 2,
    'roles': [
      {
        'k': 'pro',
        'v': 1
      },
      {
        'k': 'free',
        'v': 2
      }
      {
        'k': 'free',
        'v': 3
      }
    ]
  }
]

So I tried to use $sort:

{
  '$sort': {
     'roles.v': 1
  }
}

But it does not sort inside the array.

Ashh · Accepted Answer · 2020-05-13 12:40:26Z

3

You need to $unwind and $group to reconstruct.

([
  { $unwind: "$roles" },
  { $sort: { "roles.v": 1 }},
  { $group: {
    _id: "$_id",
    roles: { $push: "$roles" }
  }}
])

answered May 13, 2020 at 12:40

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

1 Comment

igorkf Over a year ago

Yeah, this works like a charm. Thanks for this easy approach!

Biswajit Panday · Accepted Answer · 2020-05-13 13:09:50Z

0

In order to sort by _id and if $project is needed, this will work as well.

db.getCollection("collectionName").aggregate([
    { $unwind: "$roles" },
    { $sort: { "roles.v": 1 }},
    { $group: {
        _id: "$_id",
        roles: { $push: "$roles" }
    }},
    {$project: {
        _id: "$_id",
        roles: "$roles"
    }},
    {$sort: {"_id": 1}}
])

edited May 13, 2020 at 13:09

answered May 13, 2020 at 12:59

Biswajit Panday

83710 silver badges20 bronze badges

Comments

sidhique kerala · Accepted Answer · 2022-08-24 04:14:40Z

0

You can use a simple mongdb method $sortArray The code is this:

db.collection.aggregate([
  {
    $project: {
      _id: 0,
      result: {
        $sortArray: {
          input: "$roles",
          sortBy: {
            v: 1
          }
        }
      }
    }
  }
])

answered Aug 24, 2022 at 4:14

sidhique kerala

476 bronze badges

1 Comment

sidhique kerala Over a year ago

if you want _id also, just make _id : 1

Collectives™ on Stack Overflow

Sort array of objects, using values inside each object (aggregation framework)

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related