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.

Tushar Gupta - curioustushar · Accepted Answer · 2021-07-02 11:48:55Z

6

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 } }
    ])

answered Jul 2, 2021 at 11:48

Tushar Gupta - curioustushar

57.2k24 gold badges106 silver badges110 bronze badges

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

Comments

turivishal · Accepted Answer · 2021-07-02 12:04:19Z

2

Specify collation option caseLevel in your query,

Flag that determines whether to include case comparison at strength level 1 or 2, If true, include case comparison.

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

answered Jul 2, 2021 at 12:04

turivishal

36.4k7 gold badges48 silver badges69 bronze badges

Collectives™ on Stack Overflow

mongodb unwind and sort array nested inside an array of documents

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related