DMXzone App Connect Support Product Page

sort order seems not correct

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?
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

Reply to this topic