Add option to perform case-insensitive sort when using "ascending()" or "descending()" on a text field

[CodeWithOz]

New Feature / Enhancement Checklist

• I am not disclosing a vulnerability.
• I am not just asking a question.
• I have searched through existing issues.

Current Limitation

The limitation is that I cannot use ascending() or descending() to order results in a case-insensitive manner. Consider if there are 4 available results:

[
  { name: 'value' },
  { name: 'best' },
  { name: 'Bolt' },
  { name: 'Voltage' },
]

Using ascending('name') will cause them to be ordered as:

[
  { name: 'Bolt' },
  { name: 'Voltage' },
  { name: 'best' },
  { name: 'value' },
]

Feature / Enhancement Description

The idea is to give devs the option to make ascending() and descending() search with or without case sensitivity. It could be implemented by a config option, for instance ascending('name', { ignoreCase: true });

Example Use Case

Please see the example given above.

Alternatives / Workarounds

As far as I'm aware, right now the dev has to perform the case-insensitive sort manually after getting the results, which is redundant.

3rd Party References

Not that I'm aware of. I also haven't used any other tool like parse-server before now, so my experience of such tools is limited.

[parse-github-assistant]

Thanks for opening this issue!

• 🎉 We are excited about your ideas for improvement!

[mtrezza]

Please do not post your issue in multiple places at once. I removed your posts in other threads.

[mtrezza]

The option already exists. Given the upvotes on #3973 (comment) I would assume that it works.

It's a parameter that you can pass, see

parse-server/src/Adapters/Storage/StorageAdapter.js

Line 19 in 25d5c30

caseInsensitive?: boolean,

I just noticed that there are no simple tests in /spec, only internal tests that deal directly with the DB adapter instance. Would you want to add a test and submit a PR? That could help you to verify that it works and help others who may have the same question as you. I'm also not finding this (and many other options) in the docs, maybe we need to update them?

[mtrezza]

I'm closing this as it does not seem to be a Parse Server issue.

• For help with Parse Platform we recommend our community forum or our community chat
• For general coding questions we recommend Stack Overflow using the parse-platform tag
• For network and server questions we recommend ServerFault using the parse-server tag

[CodeWithOz]

Hey thanks for the feedback! We accepted the case-sensitive search for now so I'll try to look into your suggestions when I have more free time.