I am connecting to a MySQL database to retrieve data. I would like to know how to drill down data and access sub queries. For example: I have the main table that contains a list of users and I want to be able to click one of the users from the table and view all forms they have submitted. I then want to be able to click one of those forms and see all the data from that form in the table. I can write all the queries but how do I go about setting up the links in the tables for this to work?
Unfortunately at the moment there’s no built-in solution.However it appears in requests from time to time so we will add to our idea list and look into some possible solutions on plugin side in future.
Hello,
I am connecting to a MySQL database to retrieve data. I would like to know how to drill down data and access sub queries. For example: I have the main table that contains a list of users and I want to be able to click one of the users from the table and view all forms they have submitted. I then want to be able to click one of those forms and see all the data from that form in the table. I can write all the queries but how do I go about setting up the links in the tables for this to work?
Hi ttinkham,
Thank you for your purchase.
Unfortunately at the moment there’s no built-in solution.However it appears in requests from time to time so we will add to our idea list and look into some possible solutions on plugin side in future.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables