As previously announced via banners and our newsletters, support is no longer available through this platform.
For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.
You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.
Paid customers: Please log in to your store account for support.
Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com
How can I establish the relationship of 2 tables, one where I have the orders, another where I have the products of that order. and that only when I select an order in one table will it show me the products of that order in the other table.
Currently I am doing it with DOM but it is somewhat difficult. I want to be able to generate a report with the order information above with the product data below.
Hello
You may be able to do it with Foreign Keys, and they would need to be SQL Query based tables.
The "Order detail" table would need to have an ID associated to the "Order list" table, and you would need to create a link column which would take you to the filtered table.
For example, if you click on a link in the top table, the link should be generated with something like this:
SELECT *, CONCAT('<a href="url-to-the-other-table/?wdt_column_filter[1]=',`table1`.`IDcolumn`,">Link To The Order</a>') AS LinkAnd it would generate the link to a table pre-filtered through URL by concatenating the URL with the ID of the order.
Also, you would need to enable filtering for that other table, and to find which filter # it is (wdt_column_filter[1] is for the second column in the table).
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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