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?
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.