DMXzone App Connect Support Product Page
sort order seems not correct
Asked 5 years ago
1
has this question
5 years ago 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 5 years ago
5 years ago 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 5 years ago
5 years ago 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