I have SQL queries that have been sorted by their preferred orders (which are not simple ascending or descending rules), but I notice wpdatatables always resort the data again when the table displayed if the sorting function of table enabled. Is it possible not to resort the table even when the sorting function is enabled?
If you enable sorting, the table will always sort by one of the columns by default (usually the first column). If you have custom sorting defined in the query, just disable sorting for the table, and it should work fine. Having both active at the same time is, unfortunately, not possible.
I have SQL queries that have been sorted by their preferred orders (which are not simple ascending or descending rules), but I notice wpdatatables always resort the data again when the table displayed if the sorting function of table enabled. Is it possible not to resort the table even when the sorting function is enabled?
Hello Yi-Hong Ke.
Thank you for your purchase.
If you enable sorting, the table will always sort by one of the columns by default (usually the first column). If you have custom sorting defined in the query, just disable sorting for the table, and it should work fine. Having both active at the same time is, unfortunately, not possible.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables