order-filter - issue with case-sensitive sorting

[themathman2]

Hi to all,

in our database there are entries, which names start with capital or small letters, numbers and as well special chars like "_". In our frontend we want to display a list of these entries ordered by their name.

So we used the order filter (https://loopback.io/doc/en/lb4/Order-filter.html). The result is a case sensitive ordered list. That's nice, but a bit confusing to the users. To find an entry starting with small letter a after all entries with capital letter, is not the way, which the "normal" user is expecting.

Is there any way to get the entries ordered case insensitive? In the docs i don't find anything about. The where-filter option ilike for example offers case insensitive behavior, so i hope there is as well an option in the order-filter.

Best regards
Frank