Sorting appears to be case sensitive for text data sorted via query rules or the

lindat over 11 years ago

Sorting appears to be case sensitive for text data sorted via query rules or the SortInfo data type. In my paging grids, case insensitive sorting would be more usable. What is the recommended approach for accomplishing this?...

Discussion posts and replies are publicly visible

Parents

0 Sathya Srinivasan
Appian Employee
over 11 years ago

Linda, the sorting you see is how text are usually sorted. If you want to achieve the way you want, you need to update your data to be of proper typecase. You can use the proper() function in Appian that may help you.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Sathya Srinivasan
Appian Employee
over 11 years ago

Linda, the sorting you see is how text are usually sorted. If you want to achieve the way you want, you need to update your data to be of proper typecase. You can use the proper() function in Appian that may help you.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data