I have list of Apps (from Security module - generated by wizard).
Trying to sort list by the App Name but something is not right here. Ant ideas ?
Is this a bug ?
[ATTACH=JSON]{“data-align”:“none”,“data-size”:“full”,“title”:“2018-12-19 01_16_55-Editing - Groups _ Applications.jpg”,“data-attachmentid”:85795}[/ATTACH]
maybe the field is using a lookup. If YES SC sorts the ID and not on the name. Check this
I had some problem if there are many records. In this case you have to increment php memory
this is a table with App list so not many records, it also does not use any lookup (it is wizard generated in SC).
it very much seems like a bug
Your sample (screen shot) seems to show a correct ASCII sort:
0123 … ?@ABCDEF … Z[]_abcde … z{|} …
as shown in ASCII table (my picture).
What do you expect ?
Maybe to ignore upper and lower cases ?
[ATTACH=JSON]{“alt”:“ascii table - sort order”,“data-align”:“none”,“data-size”:“full”,“title”:“ASCII.JPG”,“data-attachmentid”:85832}[/ATTACH]
Maybe this helps ?
Sincerely
Gunter Eibl
Gunter - thank you for realizing me the ASCII order. You are right, but this is not really logical.
In real life we want records sorted in more readable way.
what I want is to sort it like this:
AaBbCcDdEeFf,…
so the letter case is ignorred in sort
Any ideas ?
Choose a case-insensitive collation
select * from your_table order by your_column COLLATE utf8_general_ci
That way indexes still work and the query is fast.
The SQL setting page in SC apps has this option: “Distinguish uppercase/lowercase”
Don’t know if that has any impact on sorting, but you could try and disable it.