Question

2
Replies
232
Views
Close popover
Oleksandr Bielienov (OleksandrByelyenov)
Sberbank
Software Engineer
Sberbank
UA
OleksandrByelyenov Member since 2016 40 posts
Sberbank
Posted: March 21, 2017
Last activity: March 22, 2017
Closed

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 Experience
Moderation Team has archived post