I love the capability of filtering visible, editable data based on user id. I've turned that on, but selected to show all rows in the admin panel. However, as the admin I'm not able to edit the table itself with these settings. Is it possible to allow an admin to edit any part of the table but restrict other users to editing only records with their user id?
You would be able to edit that specific table only if you disable the "Users see and edit their own data", but there may be a better way.
Copy the "MySQL table name" from the Editing tab above this table, and create a new SQL query-based table using that name. For example, if the "Users see and edit their own data" table is wp_wpdatatable_1, create a new table linked to an existing data source -> MySQL:
SELECT * FROM wp_wpdatatable_1
You can use this table as the Admin table in the backend, and do all editing through it. The original table will only display the values of the MySQL query-based table and you wouldn't need to turn the setting on and off.
Thank you, Aleksander! When I realized that I could create a second table querying the SQL database created by the first table, the solution you described became apparent.
A limitation I've found is that if I add a column to the original table I need to delete and regenerate the Admin version. Not a big deal, I just have to keep that in mind as I go.
I love the capability of filtering visible, editable data based on user id. I've turned that on, but selected to show all rows in the admin panel. However, as the admin I'm not able to edit the table itself with these settings. Is it possible to allow an admin to edit any part of the table but restrict other users to editing only records with their user id?
Hi again Lucas
You would be able to edit that specific table only if you disable the "Users see and edit their own data", but there may be a better way.
Copy the "MySQL table name" from the Editing tab above this table, and create a new SQL query-based table using that name. For example, if the "Users see and edit their own data" table is wp_wpdatatable_1, create a new table linked to an existing data source -> MySQL:
You can use this table as the Admin table in the backend, and do all editing through it. The original table will only display the values of the MySQL query-based table and you wouldn't need to turn the setting on and off.
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
Thank you, Aleksander! When I realized that I could create a second table querying the SQL database created by the first table, the solution you described became apparent.
A limitation I've found is that if I add a column to the original table I need to delete and regenerate the Admin version. Not a big deal, I just have to keep that in mind as I go.
You're welcome, Lucas!
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
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