This fact should be front and center on your website. WPDT has the best backend and abilities to connect to various database sources...
BUT, from support:
... "Also, please note that 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..."
:(
Joins are a foundation of ANY Database or application... HOW CAN YOU NOT ALLOW THAT?
That is how the plugin works. It is not a database management tool, and it shouldn't be treated like that. It is a simple datatable plugin, which allows you to use some SQL functionalities, but not all.
Our logic is based on a PHP SQL parser which has full support for the SQL dialect for the following statement types
Using variables ( @ ), stored procedures and nested queries is not supported.
Our developers will be working on resolving the issue of editing multiple tables in a query, but at the moment it cannot be done, and there is no workaround.
But using Views (which is supported?) can't be used if 2 tables are used?
NOTE: When you say, "full support" for SQL dialect like "select"... it is standard to think selecting from 2+ tables is standard, but WPDT can't do that?
question: on a timing estimate... are we talking weeks, months, or years for allowing WPDT to be able to edit data when a SELECT is used with 2+ tables?
You can create a view from a hundred tables, and display that view through an SQL query based table. However, you cannot edit more than one of those underlying tables if you pass the proper ID.
When using the SELECT statement, you can create a table from multiple tables, but they have limitations that were described in our documentation and my previous responses.
The issue we're having with filtering, sorting, search and editing tables with JOINS, and views that come from multiple tables exists from the beginning, and there's no estimate when this will be fixed. Our developers are working on it, but SQL is a complicated language, and the same functionalities of PHPMyAdmin, or other database tools will probably never be achieved.
This fact should be front and center on your website. WPDT has the best backend and abilities to connect to various database sources...
BUT, from support:
... "Also, please note that 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..."
:(
Joins are a foundation of ANY Database or application... HOW CAN YOU NOT ALLOW THAT?
I need to edit tables with joins.
By chance, do you have a work around?
Hi Larry
That is how the plugin works. It is not a database management tool, and it shouldn't be treated like that. It is a simple datatable plugin, which allows you to use some SQL functionalities, but not all.
Our logic is based on a PHP SQL parser which has full support for the SQL dialect for the following statement types
SELECT, INSERT, UPDATE, DELETE, REPLACE, RENAME, SHOW, SET, DROP, CREATE INDEX, CREATE TABLE, EXPLAIN and DESCRIBE.
Some of them are disabled for security reasons.
Using variables ( @ ), stored procedures and nested queries is not supported.
Our developers will be working on resolving the issue of editing multiple tables in a query, but at the moment it cannot be done, and there is no workaround.
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
But using Views (which is supported?) can't be used if 2 tables are used?
NOTE: When you say, "full support" for SQL dialect like "select"...
it is standard to think selecting from 2+ tables is standard, but WPDT can't do that?
question: on a timing estimate... are we talking weeks, months, or years for allowing WPDT to be able to edit data when a SELECT is used with 2+ tables?
thanks
Hello again Larry
You can create a view from a hundred tables, and display that view through an SQL query based table. However, you cannot edit more than one of those underlying tables if you pass the proper ID.
When using the SELECT statement, you can create a table from multiple tables, but they have limitations that were described in our documentation and my previous responses.
The issue we're having with filtering, sorting, search and editing tables with JOINS, and views that come from multiple tables exists from the beginning, and there's no estimate when this will be fixed. Our developers are working on it, but SQL is a complicated language, and the same functionalities of PHPMyAdmin, or other database tools will probably never be achieved.
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