Posted: 21 Mar 2017 9:50 EDT Last activity: 22 Mar 2017 9:20 EDT
A Text sorting issue.
I have got a repeat layout with the several columns. One of them prints data as "123 days", so it is Text.
When I try to order rows by the column, I get something like: "121 days", "122 days", "123 days", "13 days", "124 days".
A property of the column is contained in the Data Base as Integer, but there is an activity, which converts it into Text adding "days".
I suppose that the solution of the issue is utilizing Number instead of Text, but displaying "days" is a business requirement and I am not able just to throw it out.
Are there any workarounds to display "days" and to order the column as Number?