I have a record with all text columns, even the integer/decimal data is being saved in text type fields. In appian I want to sort ascending/descending properly but it is taking the ASCII value of string & sorting them on that basis. Is there any work around in "gridField" with data as recordType?
Discussion posts and replies are publicly visible
No. The sorting is also not done by Appian, but by the database. Appian is only displaying the data.
Is there a specific reason to store everything as text?
No solution to do the same direct. But few solutions I can think. My recommendation is 1st one only.
1. Change the data type in DB, which is effort and time consuming.
2. Get the data from record and then convert manually to integer or decimal (say type casting) then you won't be able to use grid record as your data would be in local. So, you will end up in regular grid.
3. Duplicates the columns in the record source by adding custom field and then use those custom field for sorting.
Yes, the reason it is because the data can be dynamic. Thanks for clarifying it. Do you have any workaround to this type of scenario, other than changing the text type?
There is no work around. Especially not when that data is "dynamic", whatever that means. If you store random alphanumeric data in a field, there is no way to determine a consistent way of sorting.