Good Morning, It looks like your product is what I have been looking for, but a question first. I am looking to create a report of all users in wp_users joined with the detailed data in wp_usermeta. It appears that your product can do this, but I just want to confirm.
It is possible to create wpDataTable from the MySQL query. If you can get the data that you want in phpMyAdmin or any other database management software with your query, it is also possible to create wpDataTable from it.
"Please note: this tool is not an ultimate query generator. It simply constructs a suggestion of a query. We are constantly working to improve it, but SQL is such a complicated and flexible language that full automation for constructing queries is next to impossible. Consequently, the more complicated the query, the higher is the probability that it will not return exactly what you need. So, you will often need to play around with the resulting query."
You can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin features.
Good Morning, It looks like your product is what I have been looking for, but a question first. I am looking to create a report of all users in wp_users joined with the detailed data in wp_usermeta. It appears that your product can do this, but I just want to confirm.
Thanks, Mike Brewer
Hi Mike Brewer,
Thank you for the inquiry.
It is possible to create wpDataTable from the MySQL query. If you can get the data that you want in phpMyAdmin or any other database management software with your query, it is also possible to create wpDataTable from it.
Also it is possible to create MySQL based wpDataTable from WordPress database by using "query generator". Please take a look at this feature at Create a MySQL-query-based table by generating a query to WordPress database page from our documentation.
"Please note: this tool is not an ultimate query generator. It simply constructs a suggestion of a query. We are constantly working to improve it, but SQL is such a complicated and flexible language that full automation for constructing queries is next to impossible. Consequently, the more complicated the query, the higher is the probability that it will not return exactly what you need. So, you will often need to play around with the resulting query."
You can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin features.