Thu, 24 Sep 2026
Login

sort issue

Confluence User - 03 Mar, 2022

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

forms

2

Confluence User •
03 Mar, 2022 •
confluenceUser •
•
confluenceUser •

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".

Confluence User •
03 Mar, 2022 •
confluenceUser •
•
confluenceUser •

thanks, it worked.

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
Export As PDF
Select Box
one to many relationship
Can we create a dropdown field directly in a Joget List so that users can change the status of a record from the list view itself?
How to auto load client data after selecting it in a dropdown?
Retrieve image upload from form into PDF
Error storing data
How to generate unique ID using Textfield?
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print