Question & Answer > View Question

datalist(JDBC Datalist Database Binder) sorting not working

Confluence User - 28 Nov, 2019

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

datalists;sorting

1

Confluence User •

02 Dec, 2019 •

confluenceUser •

•

confluenceUser •

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.

1

CSV | Excel | XML | PDF

Your answer

Print

datalist(JDBC Datalist Database Binder) sorting not working

1

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

1.builder-style-d9526955-fa8c-424c-a89b-6b054500bd9b{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-bb7e3b31-d1b1-4bc7-87ed-f00530fc2341{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

1

Your answer