I have front end editing and limit users to their own data enabled on a table and I don't want the users to be able to see the user id column, however I want to be able to see the user id column in the admin section.
The excel like editor sort of works, but it only shows data for your user id in the admin section.
If you hide the column in back-end it will also be hidden in front-end. When you enable "Users see and edit only own data" feature, you can enable "Show all rows in back-end", so you can see all entries.
So, to hide the User ID column from front-end, and to see it in back-end, you would need to create a new SQL Query based table for admins in back-end. You can do it by querying the MySQL database name of the original table. So, if the first table is a manual table, you can see it's database name in the Editing tab, and you can create a table linked to an existing data source/SQL with this:
SELECT * FROM wp_wpdatatable_3
If we assume wp_wpdatatable_3 is the MySQL database name of the first table.
Hi there,
I have front end editing and limit users to their own data enabled on a table and I don't want the users to be able to see the user id column, however I want to be able to see the user id column in the admin section.
The excel like editor sort of works, but it only shows data for your user id in the admin section.
Is there any way to do this?
Hello Blair
Thank you for your purchase.
If you hide the column in back-end it will also be hidden in front-end. When you enable "Users see and edit only own data" feature, you can enable "Show all rows in back-end", so you can see all entries.
So, to hide the User ID column from front-end, and to see it in back-end, you would need to create a new SQL Query based table for admins in back-end. You can do it by querying the MySQL database name of the original table. So, if the first table is a manual table, you can see it's database name in the Editing tab, and you can create a table linked to an existing data source/SQL with this:
If we assume wp_wpdatatable_3 is the MySQL database name of the first table.
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
Thanks Aleksandar, that works perfectly.
Hello Blair
Aleksandar is assign on our other products this week, so I will answer you.
You are welcome.
I am glad that Aleksandar solution help you out.
If you have any other issue or question please open new ticket, and we help you out.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables