Skip to main content
LP_1002771114-Alexandrite
14-Alexandrite
May 2, 2022
Solved

Advance Grid Sorting - double digit numbers not working

hello. i have sorting setup for an advance grip and when i click the column with double digit numbers, it sorts only from 0-9. see pictures

LP_10027711_0-1651492819031.png

LP_10027711_1-1651492846969.png

 

LP_10027711Answer
14-Alexandrite
May 3, 2022

Had to use a regular "grid" widget to get the sorting working.

View in thread

3 replies

PEHOWE17-Peridot
17-Peridot
May 3, 2022

Hello @LP_10027711,

I have not worked with the sort, so I may be wrong, What is the data type of the column you are sorting? 
My question is do you want a numeric sort or a string sort. the results are different

 

 

Translate
LP_1002771114-AlexandriteAuthor
14-Alexandrite
May 3, 2022

its a number data type

LP_10027711_0-1651586429828.png

LP_10027711_1-1651586467710.png

 

Translate
LP_1002771114-AlexandriteAuthorAnswer
14-Alexandrite
May 3, 2022

Had to use a regular "grid" widget to get the sorting working.

Translate
Terms & ConditionsAccessibility statement