mongodb unwind and sort array nested inside an array of documents

Question

How to make sorting functional well if it is case sensitive. how can we make it correct

Please suggest best way to fix it

db.products.aggregate([
  {
    "$unwind": "$receipe"
  },
  {
    "$unwind": "$receipe.burger"
  },
  {
    "$sort": {
      "receipe.burger.name": 1
    }
  }
])

https://mongoplayground.net/p/2pnUABI_-Mr

in my example familyburger should display first rather than Paneer Burger.

Answer 1

Demo - https://mongoplayground.net/p/Vt3GQx0tdXC

• Add a new filed with to lower case using $toLower
• Sot on the lower case value

---

   db.products.aggregate([
      { "$unwind": "$receipe" },
      { "$unwind": "$receipe.burger" },
      { $addFields: { "insensitiveName": { $toLower: "$receipe.burger.name" } } },
      { $sort: { "insensitiveName": 1 } }
    ])