When I turn on the option to restrict a table so the user can only see and edit their own data, when selecting "New Entry", the fields that are supposed to allow a choice from other tables (foreign key) don't show the complete list. Only the entries that are already part of the secured table show up.
This is a problem, since adding a new row to the table, the user should have all the possible choices to select from. For some reason, the select from list is being filtered by the user ID, which shouldn't happen.
How do I fix this so all choices for the lookup tables is presented in the dropdown when the table itself is secured to the user ID?
The issue you're describing is a known bug and that it will be fixed in the next update.
Until then, here is the fix for that:
Open the Editor, under Plugins of your website's dashboard, and select wpDataTables from the drop-down menu in the top right, then choose source/class.wpdatacolumn.php file. Please take a look at the attachment, and comment the lines of code like shown in the screenshot. That'll allow the users to view all possible values defined by the foreign key.
We apologize for any inconvenience this may have caused.
When I turn on the option to restrict a table so the user can only see and edit their own data, when selecting "New Entry", the fields that are supposed to allow a choice from other tables (foreign key) don't show the complete list. Only the entries that are already part of the secured table show up.
This is a problem, since adding a new row to the table, the user should have all the possible choices to select from. For some reason, the select from list is being filtered by the user ID, which shouldn't happen.
How do I fix this so all choices for the lookup tables is presented in the dropdown when the table itself is secured to the user ID?
I have the same issue...
Please fix it
Hello Robert; hello adrienrobert.
Thank you for your purchases.
The issue you're describing is a known bug and that it will be fixed in the next update.
Until then, here is the fix for that:
Open the Editor, under Plugins of your website's dashboard, and select wpDataTables from the drop-down menu in the top right, then choose source/class.wpdatacolumn.php file. Please take a look at the attachment, and comment the lines of code like shown in the screenshot. That'll allow the users to view all possible values defined by the foreign key.
We apologize for any inconvenience this may have caused.
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