Sort By length of array mongodb query

Question

I have MongoDB document like below: is there a query to Sort the documents with the length of subscribedGroups? which can be ascending or descending.

{ 
    "_id" : ObjectId("58c29d9ec79d585c0e16b110"), 
    "subscribedGroups" : [
      ObjectId("5b28a9190c8c0d0014b03a0c"), 
      ObjectId("5b2930650b813a0014a3294d"), 
      ObjectId("5b29f1b5243d470014d6d351")
    ]
}

Do you have an example of what you've tried so far?

craigcaulfield
– craigcaulfield

2018-06-20 07:22:06 +00:00
Commented Jun 20, 2018 at 7:22 — craigcaulfield
– craigcaulfield, Commented Jun 20, 2018 at 7:22

Ashh · Accepted Answer · 2018-06-20 07:05:10Z

6

You can find the size of the subscribedGroups using $size and then easily $sort with the length of the array

db.collection.aggregate([
  {
    $addFields: {
      subscribedGroupsLength: {
        $size: "$subscribedGroups"
      }
    }
  },
  {
    $sort: {
      subscribedGroupsLength: -1
    }
  }
])

See the sample

answered Jun 20, 2018 at 7:05

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

1 Comment

moein rahimi Over a year ago

this is by far better than using old unwind, group, and then sort idea!

Collectives™ on Stack Overflow

Sort By length of array mongodb query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest