cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Help us improve the PTC Community by taking this short Community Survey! X

Advance Grid Sorting - double digit numbers not working

LP_10027711
14-Alexandrite

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

 

ACCEPTED SOLUTION

Accepted Solutions
LP_10027711
14-Alexandrite
(To:LP_10027711)

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

View solution in original post

3 REPLIES 3

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

 

 

LP_10027711
14-Alexandrite
(To:PEHOWE)

its a number data type

LP_10027711_0-1651586429828.png

LP_10027711_1-1651586467710.png

 

LP_10027711
14-Alexandrite
(To:LP_10027711)

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

Announcements


Top Tags