Hi,
I am trying to turn on sorting for a column that contains dates formatted as dd/mm/YYYY. The query brings the data into the ARI data table sorted by the dates descending, and this works fine on page load, but after that, clicking on the column header does nothing but change the arrow to point up or down. It has no noticable effect on the data. It doesn't sort or change anything at all. Removing the ORDER BY from the SQL does not change the sorting behaviour of the table either - it just shows a different set of data which then cannot be changed by clicking on the header.
The column in question is at index 1 (it is the second column in the table). When sorting is turned on but no column specific settings are applied, it sorts as if it were a string column and this works (but is inappropriate for dates, of course).
My settings are as follows:
Trying sorting type - Date instead of Date (dd/mm/YYYY) made no difference either - the little arrows change but no sorting occurs.
