complex sorting (e.g. created/modified)

emmexx 03 Dec, 2017
Is it possible to use the sorting link view to order a table using 2 fields?
I want to be able to sort the table using the created and modified datetime fields. When modified is empty or null use created else use modified, order by the result of that.
If not possible with the sorting link view, can it be done otherwise?

Thank you
maxx
Max_admin 03 Dec, 2017
Hi maxx,

If both fields have been assigned a sorting link view then you can sort by both of them, actually you can have multiple sorting fields active at the same time.

Best regards
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
emmexx 03 Dec, 2017

If both fields have been assigned a sorting link view then you can sort by both of them, actually you can have multiple sorting fields active at the same time.



That's not what I meant.

In the table I have just one column that displays the created value if modified is empty or the modified value if it is not empty.
I don't need to display both created and modified columns.

maxx
This topic is locked and no more replies can be posted.