I never used Toolset, but if it store the data in MySQL database then you should be able to retrieve the data. All you need to do is to write query that will fetch the data that you need. You should be able first to retrieve this data in phpMyAdmin or any other database management software, then you can use that query in wpDataTables and you'll get the same data.
You can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin features.
I guess the question is: I need to retrieve data from a database that has relationships. I guess I would need to write a query using the JOIN query. When using Toolset Types posts relationships, the Post Type Relationships is stored in the database "wp_postmeta" table. It stores the parent of a given type in a field _wpcf_belongs_{parent-slug}_id. Do you know if I would be able to do this with WPDatatables?
Yes probably when you want to retrieve the data from WordPress postmeta you'll have to use JOINs. wpDataTables have feature where you can easily create wpDataTable from WordPress database. You can take a look at this page from our documentation Create a MySQL-query-based table by generating a query to WordPress database.
"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."
Hi,
I'm using Toolset. Can WP data tables handle one-many and many-many relationships as defined by Toolset?
Another question. Can it output a table for an HTML table on the frontend like datatables.net does?
Thanks.
Hi Scott,
Thank you for the inquiry.
I never used Toolset, but if it store the data in MySQL database then you should be able to retrieve the data. All you need to do is to write query that will fetch the data that you need. You should be able first to retrieve this data in phpMyAdmin or any other database management software, then you can use that query in wpDataTables and you'll get the same data.
You can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin features.
Hi Milos,
I'm just learning about MySQL
I guess the question is: I need to retrieve data from a database that has relationships. I guess I would need to write a query using the JOIN query. When using Toolset Types posts relationships, the Post Type Relationships is stored in the database "wp_postmeta" table. It stores the parent of a given type in a field _wpcf_belongs_{parent-slug}_id. Do you know if I would be able to do this with WPDatatables?
Thanks!
Scott.
Hi Scott,
Yes probably when you want to retrieve the data from WordPress postmeta you'll have to use JOINs. wpDataTables have feature where you can easily create wpDataTable from WordPress database. You can take a look at this page from our documentation Create a MySQL-query-based table by generating a query to WordPress database.
"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."