Case insensitive sort on a field using App Search

We're using Elastic Enterprise App Search and want to be able to sort on field names without case sensitivity. It seems that the only way to to this is to bypass the App search APIs and hit the underlying Elastic cluster however this is not ideal because throughout our entire integration with Elastic, nowhere are we hitting Elastic directly and that significantly increases the complexity of our integration instead of simply being able to sort on a field without case sensitivity.

Does anyone have any ideas on the best way to accomplish this?

The other idea we had was to index the field with all lowercase but this is not ideal either because we want the data in our fields to reflect the actual values as they exist in the database (for displaying them to the user for example).

Thank you in advance,

I have the same issue any answer?

I'd suggest indexing both a mixed-case field and an all-lower-case version of the field, so that you can sort on one, and display the other.

If you have a support relationship with Elastic, you could also file an Enhancement Request to have the sort API updated to respect case insensitivity.

1 Like