We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
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."