Case insensitive sorting in MongoDB

by

Update:
As of now mongodb have case insensitive indexes:

Users.find({})
  .collation({locale: "en" })
  .sort({name: 1})
  .exec()
  .then(...)

shell:

db.getCollection('users')
  .find({})
  .collation({'locale':'en'})
  .sort({'firstName':1})

Update: This answer is out of date, 3.4 will have case insensitive indexes. Look to the JIRA for more information https://jira.mongodb.org/browse/SERVER-90

Unfortunately MongoDB does not yet have case insensitive indexes: https://jira.mongodb.org/browse/SERVER-90 and the task has been pushed back.

This means the only way to sort case insensitive currently is to actually create a specific “lower cased” field, copying the value (lower cased of course) of the sort field in question and sorting on that instead.

More Related Contents:

  1. How to query documents using “_id” field in Java mongodb driver?
  2. How to insert multiple documents at once in MongoDB through Java
  3. How to update value of specific embedded document, inside an array, of a specific document in MongoDB?
  4. How to approach this hackerrank puzzle?
  5. Assign information to element in array in java [closed]
  6. What is the internal sorting technique used in comparator and comparable interfaces and why? [duplicate]
  7. How to sort by two fields in Java?
  8. How to sort a HashMap in Java [duplicate]
  9. Best way to list files in Java, sorted by Date Modified?
  10. Sorting HashMap by values [duplicate]
  11. Sort a Map by values
  12. Collections.sort with multiple fields
  13. How to sort an array of ints using a custom comparator?
  14. Android-java- How to sort a list of objects by a certain value within the object
  15. Mongodb Increment value inside nested array
  16. Is it faster to add to a collection then sort it, or add to a sorted collection?
  17. How to do a Mongo aggregation query in Spring Data?
  18. sorting Lists after groupingBy
  19. Sort List in reverse in order
  20. MongoDB $aggregate $push multiple fields in Java Spring Data
  21. Sort a parallel array using Arrays.sort()
  22. Sort large arrays of primitive types in descending order
  23. How do I sort two arrays in relation to each other?
  24. Automatically sorted by values map in Java
  25. How to sort JTable in shortest way?
  26. Apache-POI sorting rows in excel
  27. Sorting int array in descending order [duplicate]
  28. Sorting a List in parallel without creating a temporary array in Java 8
  29. Java sort ArrayList with custom fields by number and alphabetically
  30. TransactionRequiredException Executing an update/delete query

Leave a Comment