If you mean on table that you provide on related link, we can see that sorting is working fine. If you want to table be sort on specific column you can set that with option Use as default sorting column on SORTING tab in column settings of that specific column and choose Default sorting direction.
We notice that. Also we found that you set column type to String and we change it to Date but results are the same. Can you please send us that table from database so we can tested in our local environment? Thank you
What was the answer to this topic? I got the same problem.
The column type is set to "DateTime" and the cells contains time and date in this format: 26/05/2018 14:00 (dd/MM/yyyy HH:mm). When I use conditional formatting and set ">%TODAY%", all previous dates formatted, so the table seems to understand the format.
You have this issue because of the date_format function in your view that set date format that cause this issue.(attachment 1) If you change that date format like this in your view(attachment 2) sorting will work just fine.
If I enable sorting and attempt to sort a table on a date field, it doesn't work:
Configuration: MySQL table, "Allow sorting for the table" - on, "Enable server side processing" - Off,
Field: 'Date' type of field, Field: "Allow sorting for this column" - on, Field: "Sort table by this column on load" - on
I've seen other ticket similar to this and according your answer I activated the Server Side processing, but still not working for me.
Hi Manel,
Thank you for your purchase.
If you mean on table that you provide on related link, we can see that sorting is working fine. If you want to table be sort on specific column you can set that with option Use as default sorting column on SORTING tab in column settings of that specific column and choose Default sorting direction.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi
The link is this one https://aporofobia.info/descubre-los-tipos-de-violencia/base-de-datos/
As you can see the resulting order if you use the SORT option for the column is not correct, I think....
I mean, I would expect the table rows starting by the older or newest item. I attach 2 images:
1- Settings order for the column
2- Order resolt
I'll reply in private with wp acces just if you want to check
Hi Manel,
We notice that. Also we found that you set column type to String and we change it to Date but results are the same. Can you please send us that table from database so we can tested in our local environment? Thank you
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi Manel,
Yes we notice that, so can you please send a database so we can make table from this view?
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Amazong!! Thank you very much!!
Hi Manel,
You are welcome.
If you have any more issues feel free to open a new ticket, we will gladly help.
We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks!
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
What was the answer to this topic? I got the same problem.
The column type is set to "DateTime" and the cells contains time and date in this format: 26/05/2018 14:00 (dd/MM/yyyy HH:mm). When I use conditional formatting and set ">%TODAY%", all previous dates formatted, so the table seems to understand the format.
Hi orjanmen
The answer was this for me:
Hi Manel,
You have this issue because of the date_format function in your view that set date format that cause this issue.(attachment 1) If you change that date format like this in your view(attachment 2) sorting will work just fine.