I have defined a field (BenoetigtAm) as DATE in AG. It holds values like 2020-11-06 or 2021-11-18.
I have set
Code: Select all
$options->DefaultSortField = 'Log_Fertig_Zeit ASC, BenoetigtAm ASC, ID_Container_Platz_aktuell DESC';
BenoetigtAm = Benötigt am, 2nd criteria
ID_Container_Platz_aktuell = Platz (aktuell), 3rd criteria)
This does not work.
When I set the fields to be sorted directly in the generated application (Filter -> set the sort as above) the sorting does work. This makes me think, a field of type DATE might not be handled correctly.
This first image shows the use of
Code: Select all
$options->DefaultSortField = 'Log_Fertig_Zeit ASC, BenoetigtAm ASC, ID_Container_Platz_aktuell DESC';
Code: Select all
<a href="http://localhost/mytable.php?SortField=12+asc%2C5+asc%2C3&SortDirection=desc">Filter Link gespeichert</a>