I have a list based on selecting a VIEW. The view has an "ORDER BY" but when wpDataTables (pro) displays the list, it is NOT in the correct order (i.e. alphabetical desc) apparently because I have "Allow sorting for the table" as "active".
Is there a way to allow both the SQL "order by" and end-user sorting on various fields that are not sorted by the view?
YES, it definitely is sorted correctly when accessed from phpMyAdmin AND if I do NOT turn on the "Allow sorting" in the plugin, the display lists in the correct order.
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also point me to the table ID and column where the sorting is not working so I can take a look.
Could you please describe how this ticket was resolved? I have the same problem. The sorting pointed in SQL seems to be lost when allow users to change sorting manually.
I am not sure if this has been resolved. I set aside the idea of using wpdatatables. It likely has a conflict over whether wpdatatables shall control or whether wpdatatables can use a view that it did not formulate.
In reality, I'd prefer a plugin that would use it's own tables IN the WP database and NOT use posts or pages but rather pure PHP code.
I have a list based on selecting a VIEW.
The view has an "ORDER BY" but when wpDataTables (pro) displays the list, it is NOT in the correct order (i.e. alphabetical desc) apparently because I have "Allow sorting for the table" as "active".
Is there a way to allow both the SQL "order by" and end-user sorting on various fields that are not sorted by the view?
Hi dnuttall,
Thank you for your purchase.
Can you please tell me when you see the data from the view in php my admin is the order by sorted correctly?
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
YES, it definitely is sorted correctly when accessed from phpMyAdmin
AND
if I do NOT turn on the "Allow sorting" in the plugin, the display lists in the correct order.
Thanks!
HI dnuttall,
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also point me to the table ID and column where the sorting is not working so I can take a look.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Could you please describe how this ticket was resolved? I have the same problem. The sorting pointed in SQL seems to be lost when allow users to change sorting manually.
I am not sure if this has been resolved. I set aside the idea of using wpdatatables. It likely has a conflict over whether wpdatatables shall control or whether wpdatatables can use a view that it did not formulate.
In reality, I'd prefer a plugin that would use it's own tables IN the WP database and NOT use posts or pages but rather pure PHP code.