sort issue

 
1
0
-1

can someone shed the light on how the sort work in the grid (list grid and form grid) when I specify the column to use for sorting that column data changes to numeric. messing up my table.

original data.PNG 

after save.PNG

sort_config.PNG

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      thanks, it worked.

        CommentAdd your comment...
      1.  
        1
        0
        -1

        Use a non-existent field name for the grid property "Field ID for Sorting". Joget will create a new table column in your database to store the sorting sequence, i.e. 0,1,2,3,4,5.... By "non-existent field name" I mean this field name is not used anywhere in your form, i.e. mySortGrid1. If your form has many form grids, provide unique field names for all the "Field ID for Sorting".

          CommentAdd your comment...