Thu, 24 Sep 2026
Login

Datalist : sorting by date not working properly

Confluence User - 21 May, 2019

Hello,

I'm having an issue when sorting a datalist using a date column. The sorting appears not to be considering the datetime to perform a chronological sorting but the string value and performs an alphabetical sorting (hence using only the "day" part in my case).

Am I missing something?

Thanks for the help

Baptiste

datalists

2

Confluence User •
22 May, 2019 •
confluenceUser •
•
confluenceUser •

Hi Camilo, Indeed it is JDBC! I get the point. Because everything is "string" in the database, it cannot know it is a date field. Is there a workaround with JDBC or should i use only form source? Thanks a lot, Baptiste

Confluence User •
22 May, 2019 •
confluenceUser •
1 •
confluenceUser •

OK Solved.

When using JDBC, it is necessary to use STR_TO_DATE(field, "format") to ensure that the column is a date.

Thanks for the insight Camilo.

Cheers

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