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,
Grant