Case Insensitive Query

[dblythy]

Is it possible to order queries case insensitive? Currently "ascending" orders strings by case sensitivity.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[ADSRP]

I have the same problem.

"Is it possible to order queries case insensitive? Currently "ascending" orders strings by case sensitivity."

#3973 (comment)

[SkyGanfor]

Same, would love to have this functionality.

[mtrezza]

I think this should be possible by now with Parse.Query.find({ caseInsensitive: true }). This adds en collation to the query which should result in collation not only for the query conditions but also for the sorting.

[CodeWithOz]

@mtrezza does that option still work? I just tried it and found that:

1. caseInsensitive is not part of the properties exposed by Query.FindOptions
2. the results were still not sorted in a case-insensitive manner

[evtimmy]

caseInsensitive option is not supported in Parse.Query, I had to use DatabaseController instead, where the option is supported. Here's an example:

   const databaseController = Parse.Server.database
   const result = await databaseController.find(
        '_User', 
        { username: username }, 
        { caseInsensitive: true }
    )