MongoDB Sorting Nested Array Fields

Question

I have a collection of item that has price depending on user membership (silver, gold, platinum)

{ 
  ..
  memberships: [
   {level: "silver", price: 100},
   {level: "gold", price: 90},
   {level: "platinum", price: 80}
  ]
}

when silver users browse for items, they will need to see items sorted by price using memberships price where level is silver.

How do I sort this ?

Does this answer your question? Sort nested array of objects — nimrod serok
– nimrod serok, Commented May 30, 2022 at 16:06

Ashok · Accepted Answer · 2020-12-16 04:31:48Z

1

You can use $unwind and then $sort in aggregation pipeline. eg: here

db.collection.aggregate(
{ $unwind: "$memberships" },
{ $sort: { "memberships.price": 1 }},
{ $group: {
    _id: "$_id",
    "memberships": { $push: "$memberships" }
  }
})

answered Dec 16, 2020 at 4:31

Ashok

2,9621 gold badge15 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

MongoDB Sorting Nested Array Fields

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related