DMXzone App Connect Support Product Page
sort order seems not correct
Asked 15 Jul 2019 09:36:05
1
has this question
15 Jul 2019 09:36:05 Edgar Tossijn posted:
My webpage archief.kohnstamminstituut.nl shows a very long list of publications. In the Database Source Query Builder I have defined to sort the data DESC by year (second column; jaar) and (if applicable) number (third column; rapport).Sorting the second column (jaar) seems to be correct. However, in the third column (rapport), sorting is not correct. In the year 2018, numbers in the third column start with 9-hundreds instead of 1-thousands.
How do I correct this?
Replies
Replied 18 Jul 2019 08:48:44
18 Jul 2019 08:48:44 Teodor Kuduschiev replied:
Hi Edgar,
Can you provide some step by step explanation on how to recreate the issue on your page?
Can you provide some step by step explanation on how to recreate the issue on your page?
Replied 22 Jul 2019 09:04:37
22 Jul 2019 09:04:37 Edgar Tossijn replied:
Hi Teodor,
With Database Source Query Builder I selected the columns title, author, year, number and download.
Filters (contains): year and title and author and number.
Sort order (DESC): year, number
With Database Source Query Builder I selected the columns title, author, year, number and download.
Filters (contains): year and title and author and number.
Sort order (DESC): year, number