1
0
-1

i have a problem when sorting data using multiple column, i'm using JDBC Datalist Binder this is my query :

select md.id,md.kode_divisi,md.nama_divisi,md.valid_from,md.valid_to,md.active from jwdb.vw_mst_divisi md order by md.active desc,md.kode_divisi asc

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

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      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.



        CommentAdd your comment...