OleksandrByelyenov Member since 2016 40 posts
Posted: March 21, 2017
Last activity: March 22, 2017

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

User Interface
Moderation Team has archived post
Share this page LinkedIn