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

Advance Grid Sorting - double digit numbers not working

  • May 2, 2022
  • 1 reply
  • 1470 views

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

 

Best answer by LP_10027711

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

1 reply

P
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

 

 

L
LP_1002771114-AlexandriteAuthor
14-Alexandrite
May 3, 2022

its a number data type

LP_10027711_0-1651586429828.png

LP_10027711_1-1651586467710.png

 

L
LP_1002771114-AlexandriteAuthorAnswer
14-Alexandrite
May 3, 2022

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

Terms & ConditionsAccessibility statement