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 :

looking good
but if this query i put it in "SQL Select Query" (JDBC Datalist Database Binder) then something wrong with result

result

i still set datalist properties to standart

Help me with my problem, have any idea?
Thanks in advance
best regard
Muhammad Khafidz