Mongodb sort with case insensitive manner

by

You need to use collation here with locale: "en"

db.collection.find({}).collation({ locale: "en" }).sort({ name: 1 })

So for the below document

{ "_id" : 1, "name" : "Bhavik" }
{ "_id" : 2, "name" : "Jay" }
{ "_id" : 3, "name" : "atul" }

You will get

{ "_id" : 3, "name" : "atul" }
{ "_id" : 1, "name" : "Bhavik" }
{ "_id" : 2, "name" : "Jay" }

More Related Contents:

  1. Mongoose always returning an empty array NodeJS
  2. $lookup multiple levels without $unwind?
  3. Mongoose, update values in array of objects
  4. In Mongoose, how do I sort by date? (node.js)
  5. mongoError: Topology was destroyed
  6. Setting expiry time for a collection in mongodb using mongoose
  7. MongoDB/Mongoose querying at a specific date?
  8. Making mongoose.js queries run synchronously
  9. How to populate a sub-document in mongoose after creating it?
  10. Mongoose/mongoDB query joins.. but I come from a sql background
  11. mongoose custom validation using 2 fields
  12. (node:3341) DeprecationWarning: Mongoose: mpromise
  13. Mongoose deleting (pull) a document within an array, does not work with ObjectID
  14. How to set limit for array size in Mongoose schema
  15. Mongoose populate nested array
  16. MongooseError – Operation `users.findOne()` buffering timed out after 10000ms
  17. MongoDB – get documents with max attribute per group in a collection
  18. Connecting Heroku App to Atlas MongoDB Cloud service
  19. how to use populate and aggregate in same statement?
  20. Mongoose nested query on Model by field of its referenced model
  21. How do I get the objectID after I save an object in Mongoose?
  22. Mongoose password hashing
  23. Node.js – Mongoose – Check if a collection exists
  24. log all queries that mongoose fire in the application
  25. Combine two OR-queries with AND in Mongoose
  26. Mongoose findOneAndUpdate and runValidators not working
  27. Mongoose select fields to return from findOneAndUpdate
  28. mongoose recursive populate
  29. Heroku app crashes after MongoDB updated to 3.0
  30. Error at connecting to MongoDb Atlas Server

Leave a Comment