If you take a look at our documentation about wpdatatables constructor you will notice that constructor is just a helper.
"Please note: to use this plugin feature you need to have at least basic knowledge of SQL, it is assumed that you can create the table in some MySQL data manager (PHPMyAdmin, MySQL Workbench) and prepare a SQL query that will return the data that you need. If you do not know how to use MySQL, refer to <a href=”/documentation/creating-new-wpdatatables-with-table-constructor/”>creating tables with Table Constructor</a> section which will explain how to create complete tables or MySQL queries without this knowledge. Please be advised that preparing MySQL queries for you is not included in plugin support, but can be done as a paid customization service."
So when you have queries like that our suggestion is to make a VIEW in phpmyadmin or any other database management system and see if it is returning the right results. If the query is returning the desired result use that as an input for Add from data source option when creating tables.
when using wpDataTable constructor to create a sql table, i'm choosing post date and post title and its stuck on the turning arrows
Hi iias,
Thank you for your purchase.
If you take a look at our documentation about wpdatatables constructor you will notice that constructor is just a helper.
"Please note: to use this plugin feature you need to have at least basic knowledge of SQL, it is assumed that you can create the table in some MySQL data manager (PHPMyAdmin, MySQL Workbench) and prepare a SQL query that will return the data that you need. If you do not know how to use MySQL, refer to <a href=”/documentation/creating-new-wpdatatables-with-table-constructor/”>creating tables with Table Constructor</a> section which will explain how to create complete tables or MySQL queries without this knowledge. Please be advised that preparing MySQL queries for you is not included in plugin support, but can be done as a paid customization service."
So when you have queries like that our suggestion is to make a VIEW in phpmyadmin or any other database management system and see if it is returning the right results. If the query is returning the desired result use that as an input for Add from data source option when creating tables.
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