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
I'd like to know if I can write my own SQL query to populate a table with information from post meta values, then allow front-end editing to those fields. Is it possible to pull this data in dynamically, then edit and save it back to the database?
Thank you.
Hello Jay.
Thank you for your interest in our plugin.
You can create your own query, of course. But there are some limitations to this.
Please take a look at our documentation about front-end editing. While you can edit SQL query based tables both in front-end and in back-end, only one MySQL table can be edited at a time. Queries from multiple tables with joins cannot be used as an editable feature, since SQL UPDATE and INSERT statements are generated automatically, and there currently is no way to update multiple tables – but this problem is being investigated and pursued.
If you're pulling the data out of one SQL table, then you should be able to edit those entries without much issues.
My advice would be to visit our sandbox site and add your database in the main settings, as a separate DB connection. Then you can then create a new table using that separate DB connection, and see if it will pull all data and edit it properly.
wpDataTables is a WYSIWYG (What You See Is What You Get) concept based plugin, so if you're able to edit it in back-end - you will be to edit it in front-end as well.
Please let me know if you have any more questions.
Best regards.
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
Thanks, this was helpful. Unfortunately, I need to update both wp_posts and wp_postmeta tables (you've probably encountered users who want to do this before). If there are any advancements or updates which tackle this, I'd be very interested.
Thanks again, great plugin.
Hello again Jay.
You can try preparing a MySQL view (a stored query), which will return the data that you need, call it e.g. “view1” and then build a wpDataTables based on a simple query like “SELECT * FROM view1″.
Please note some this when working with the server-side processing feature:
I cannot say that it will work 100%, but you can definitely try.
Personally, I created a view from 3 tables and was able to edit them all. On another occasion, I created a view from 2 tables, and wasn't able to edit the second one.
Best regards.
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