I've created a wpDataTables table with a relational column that STORES the ID from a foreign table, but DISPLAYS a NAME column from that table.
IF you edit in in STANDARD mode through the wpDataTables admin, it will properly store the ID value from the other table as expected.
IF you edit in EXCEL-LIKE mode through the wpDataTables admin, it will INCORRECTLY STORE the NAME column value from the foreign table.
The Editor Input type is set to "Single-value selectbox" and properly displays the NAME column values from the foreign table for BOTH the Standard and Excel-like editors.
BUG: The Excel-like editor improperly stores the DISPLAY value instead of the FOREIGN KEY value.
See attachments for relevant column settings for the "Brand" column we are having trouble with.
Thanks for reaching out to us about this. You're actually referring to the database entry, correct? I tested the Foreign Key feature and verified that, while the data is correctly displayed in both Standard and the Excel-like editor, the data stored in the database is incorrect.
The issue has been forwarded to our developers for testing. I'll get back to you as soon as I hear from them.
Our developers confirmed they are aware of this bug, and that it will be fixed in the future. At the moment, we don't have any quick-fixes for the issue, unfortunately.
I've created a wpDataTables table with a relational column that STORES the ID from a foreign table, but DISPLAYS a NAME column from that table.
IF you edit in in STANDARD mode through the wpDataTables admin, it will properly store the ID value from the other table as expected.
IF you edit in EXCEL-LIKE mode through the wpDataTables admin, it will INCORRECTLY STORE the NAME column value from the foreign table.
The Editor Input type is set to "Single-value selectbox" and properly displays the NAME column values from the foreign table for BOTH the Standard and Excel-like editors.
BUG: The Excel-like editor improperly stores the DISPLAY value instead of the FOREIGN KEY value.
See attachments for relevant column settings for the "Brand" column we are having trouble with.
Hello there.
Thank you for your purchase.
Thanks for reaching out to us about this. You're actually referring to the database entry, correct? I tested the Foreign Key feature and verified that, while the data is correctly displayed in both Standard and the Excel-like editor, the data stored in the database is incorrect.
The issue has been forwarded to our developers for testing. I'll get back to you as soon as I hear from them.
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
Hi again.
Our developers confirmed they are aware of this bug, and that it will be fixed in the future. At the moment, we don't have any quick-fixes for the issue, unfortunately.
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