Hi I'm looking for 2-3 main options, I have try the sandbox, but not find how to make it if it's possibe.
1. Edit data on linked table ?
Sample : a table with ID, MonitorName, a table with ID, RoomNr, a table like course with ID, Description, IDMonior, IDRoom,. I could build a table on sql query with Course Description, MonitorName, RoomNr. But wenn I try to Edit it, it does not save it in the 3 first table like I esperate.
2. To do It properly of course i need to reduce the imput form on the existing value from Monitor and Room (and have separate table to edit them)
3. If y try to delet a Monitor with ist used in a course (if my DB as a relationship) will it rease an error in your plugin ?
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
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.
I fast have it with the foreign Key, but my only Problem ist (perhaps an idee for new feature) in the Configure relationship I can only choose one Display value. Like in my DB i have something like
Id / First name / last name / Born year /....
1 / Bob / Dylan /1976 /....
2 / Bob / Doe / 1983 /....
3 / John / Doe / 2010 /....
4 / John / Doe /1941 /....
If I choose the name as display value I will not be able to now if it's one or the other. It will be great to be able to choose more than one display value and add them as virtuelle colone im frontend table.
OR Is their an other way to show in the frontende table some other colone from the remote table linked on to the the selected foreingn key ? Somethink like a view, but without loosing the editing option on main table Feld.
Hello, SQL ist not a Problem, I make it in SQL and it work well to make the table (see Picture 1).
But wenn I try to work on the edition I have some trouble. How can I link my concat result as "Foreignkey displayed value" ? And of course how can I make that the "possible value for column" also take it (see Picture 2). I have no Problem writting a SQL statement, but It seem the plugin not alloud it ?
Sorry, Mickael, I don't understand what you're trying to do.
From what I see, you want the "Collaborateur" column from table #10 (SQL) to pull values from table #9 by concating first and last name?
That's not possible.
The only thing you can do is perform the similar CONCAT function in table #9, so the "prenom" column displays both first and last name. After that you should be able to pull the full name into table #10.
Hi I'm looking for 2-3 main options, I have try the sandbox, but not find how to make it if it's possibe.
1. Edit data on linked table ?
Sample : a table with ID, MonitorName, a table with ID, RoomNr, a table like course with ID, Description, IDMonior, IDRoom,. I could build a table on sql query with Course Description, MonitorName, RoomNr. But wenn I try to Edit it, it does not save it in the 3 first table like I esperate.
2. To do It properly of course i need to reduce the imput form on the existing value from Monitor and Room (and have separate table to edit them)
3. If y try to delet a Monitor with ist used in a course (if my DB as a relationship) will it rease an error in your plugin ?
Thanks for your response
Hello Mickael
Thank you for your interest in our plugin.
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
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.
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
I fast have it with the foreign Key, but my only Problem ist (perhaps an idee for new feature) in the Configure relationship I can only choose one Display value. Like in my DB i have something like
Id / First name / last name / Born year /....
1 / Bob / Dylan /1976 /....
2 / Bob / Doe / 1983 /....
3 / John / Doe / 2010 /....
4 / John / Doe /1941 /....
If I choose the name as display value I will not be able to now if it's one or the other. It will be great to be able to choose more than one display value and add them as virtuelle colone im frontend table.
OR Is their an other way to show in the frontende table some other colone from the remote table linked on to the the selected foreingn key ? Somethink like a view, but without loosing the editing option on main table Feld.
Thanks
I agree with you, that this would be a great feature Mickael, but unfortunately it is not possible.
At the moment, pulling data from other tables is only possible with custom SQL queries, but then there's a chance that editing will not work.
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
Hello, SQL ist not a Problem, I make it in SQL and it work well to make the table (see Picture 1).
But wenn I try to work on the edition I have some trouble. How can I link my concat result as "Foreignkey displayed value" ? And of course how can I make that the "possible value for column" also take it (see Picture 2). I have no Problem writting a SQL statement, but It seem the plugin not alloud it ?
Sorry, Mickael, I don't understand what you're trying to do.
From what I see, you want the "Collaborateur" column from table #10 (SQL) to pull values from table #9 by concating first and last name?
That's not possible.
The only thing you can do is perform the similar CONCAT function in table #9, so the "prenom" column displays both first and last name. After that you should be able to pull the full name into table #10.
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