Dear ARI-soft,

How to make data table correctly sortable?
Dates in Mysql are stored in "yyyy-mm-dd" format.
In site data table I want to present dates in "%d-%m-%y" format. But sorting by pushing the table header results not in date sorting but in string sorting.

What to do? Could you help me?

The SQL query in ARI Datables module is:

SELECT Date_format(`Datum`,'%d-%m-%y') as Datum2,`Repetitie/Concert`,`Neue Bach Ausgabe`,`Moeilijke stukken`,`Tractant`,`Locatie` FROM `Jaarkalender RBE` ORDER BY `Datum` ASC

Regards,

Ben Hillen

Hello,

What table widget is used? Do you use server side pagination or client side?

Regards,
ARI Soft

I added two images

Now two images in ZIP

Open module settings page and navigate to "Choose table type -> ARI Data Table -> Columns settings" parameters section. Inter 0 in "Column index" and select "Date" in "Sorting type" dropdown:



Regards,
ARI Soft

This works.

Thank you.