Sorting, case insensitive

pete letkeman

How can I make sort a result from a query used in an API by case insensitive?

Here is some sample data in a sortBy field:

Apple

ape

Abe

apricot

Bernie

banana

Button

bill

-------------------

After sorting using Xano the results are:

Abe

Apple

Bernie

Button

ape

apricot

banana

bill

--------------------------

However I'd like to have the following:

Abe

ape

Apple

apricot

banana

Bernie

bill

Button

-----------------------

How can I accomplish this?

Michael Udinski

You can use the array filter sort and use itext to sort text case-insensitive:

https://youtu.be/k8uQQs419PU