I'm in the appian designer and I'm trying to sort my datasets by description.
Normally if you use an underscore "_" as the first character, entries with the "_" as its first character will appear at the top of the list when sorting alphabetically.
Not with Appian however
Anything with an "_" as its first character sorts to the bottom of the list, not the top.
Example
Any NameBny NameCny Name_ny Name
Why? No one else seems to do it this way. I've worked with dozen of applications and none of them sort the "_" character last like this.
Is this a bug or is Appian taking a page from MS' playbook and assumes that it knows better than everyone how sorting should work?
How can I fix this or find a work around? I don't want to resort to using 1, 2, 3... in order to force my descriptions to sort properly.
Discussion posts and replies are publicly visible
To Reproduce
That Description - the one right between the Name and Last Modified columns.
I guess this is a Unix thing because Microsoft, Excel, Google Drive, Google Sheets, and a pile of other programs sort the "_" character first along with !, #, $ etc. even thou its between the Upper and Lower case letters on an Ascii chart.
I can use !_ to get the sort order I'm looking for since the ! is a lower ascii value than both numbers and letters.
Its more an OCD thing as I use the "_" character a lot in order to force a sort order without having to jump through hoops. I was expecting to sort near the top of the sort order like these other programs do.
Works for me in designer for me as well. This one is certainly interesting. Wonder if it perhaps has something to do with the collation on the server?
https://docs.appian.com/suite/help/23.2/Prerequisites.html#verify-the-server-system-locale-setting