Sort based on how many items are in an array using mongoose and MongoDB

Question

I have a Post model that has a likes array that contains the ObjectId of the user that liked the Post, I would like to sort Posts based on how many likes they have received.

I'm sure I would use $size, $sort and aggregate, but everything I have tried doesn't seem to work. Can you use $size within $sort? What would be the correct way of doing this? and is there a specific way of doing it with mongoose?

YuTing · Accepted Answer · 2022-04-01 02:32:39Z

1

db.collection.aggregate([
  {
    $set: {
      size: { $size: "$likes" }
    }
  },
  {
    $sort: {
      size: -1
    }
  }
])

mongoplayground

answered Apr 1, 2022 at 2:32

YuTing

6,6692 gold badges8 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

Sort based on how many items are in an array using mongoose and 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