When you have some complex queries our suggestion is to make a VIEW in phpmyadmin or any other database management system and see if it is returning the right result. If the data is right you can use that query as an input for Add from data source when creating tables.
Also using DATADIFF i assume that the query will return the data but I can not guarantee that some functions like search, sorting will work.
Hi,
I am trying to use DATADIFF query function with no success.
does wpDataTables know all SQL query?
Hi lior_c,
Thank you for your purchase.
When you have some complex queries our suggestion is to make a VIEW in phpmyadmin or any other database management system and see if it is returning the right result. If the data is right you can use that query as an input for Add from data source when creating tables.
Also using DATADIFF i assume that the query will return the data but I can not guarantee that some functions like search, sorting will work.
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