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