Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
Hi
I think you have to use the "Datalist Builder > Properties > Order" and "Order By" option fields to set the list order. Unfortunately you can only set a single column to sort.
i have a problem when sorting data using multiple column, i'm using JDBC Datalist Binder this is my query :
if this query execute in mysql client(HeidiSQL) then this is my result :
![](/community/download/attachments/76939722/image2019-11-28_9-47-32.png?version=1&modificationDate=1574909958000&api=v2)
looking good
but if this query i put it in "SQL Select Query" (JDBC Datalist Database Binder) then something wrong with result
![](/community/download/attachments/76939722/image2019-11-28_9-50-57.png?version=1&modificationDate=1574909958000&api=v2)
result
![](/community/download/attachments/76939722/image2019-11-28_9-51-28.png?version=1&modificationDate=1574909958000&api=v2)
i still set datalist properties to standart
![](/community/download/attachments/76939722/image2019-11-28_9-52-37.png?version=1&modificationDate=1574909958000&api=v2)
Help me with my problem, have any idea?
Thanks in advance
best regard
Muhammad Khafidz