Thu, 24 Sep 2026
Login

sort order for dates and numbers in datalists - UX

Confluence User - 01 Mar, 2021

I really need a datalist UX (client side) sort that works . I understand Joget stores everything as text but i need to sort amounts as numbers, account numbers as numbers and dates accordingly. this is a financial requirement. 


I dont mind if there is a external js library that works, i cant even begin to make sense of the footable implementattion that Joget seems to use.

datalists

1

Confluence User •
02 Mar, 2021 •
confluenceUser •
•
confluenceUser •

Datalist sort uses lexicographic order, the app treats the column values as *strings* and compares character by character left to right. To produce a numerical order, use datalist JDBC Binder and *CAST* the column to UNSIGNED, for example:

SELECT
       id
     , CAST(c_thisIsANumberField AS UNSIGNED) as Number
from
       app_fd_myTable
1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Can I make list that read the Running Processes ? I want to add my own list and not using the list in monitor
Can I make list that read the Running Processes ? I want to add my own list and not using the list in monitor
How to customize datalist process formatter
Please help me fix the problem. The text field is pulling data from a datalist with more than 50k records and the browser hangs.
Please help me fix the problem. The Pop up select box is pulling data from a datalist with more than 50k records and the browser hangs.
I want to have a visibility control for hyperlink based on the date in a list builder, what type of operator I should use and how?
I Want to Add , Add to Cart functionality like Swiggy or Zomato This is possible in joget?
List Question
Create Folder on the Home Page
Async search list with ajax
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print