You can use this feature only when users are logged into your WordPress site, and using their User ID. Please take a look at our documentation about Users see and edit only own data feature.
If you need them just to see their details, without being able to edit them, you can create a manual table as an admin; go to the Editing tab, and enable editing temporarily; copy "MySQL table name for editing" and create a new table linked to an existing data source. There, choose MySQL, and use the query:
SELECT * FROM wp_wpdatatable_1 WHERE userid = %CURRENT_USER_ID%
Assuming the MySQL table name for editing is wp_wpdatatable_1. This filters the table, so it always shows the values of a currently logged in user, using placeholder %CURRENT_USER_ID%.
Can Table row be display to specific user
Example: My current employee name :
1.Dipa
2. John
3. Rose
I like to show their date of birth, current salary
but this data will be enter by the manager from one table. but i want to show specific row related to the employee name when emplyee login.
Like when 1. Dipa login i want to show only Dipa rows to Dipaa same for when John login I want to show rows related to John only.
And This row can be only view not editable by that user but by only manager.
If there is any tutorial regarding this then povide the link and i will look and purchase
Thank you
waiting for your good reply
Hello Dipananda
Thank you for your interest in our plugin.
You can use this feature only when users are logged into your WordPress site, and using their User ID. Please take a look at our documentation about Users see and edit only own data feature.
If you need them just to see their details, without being able to edit them, you can create a manual table as an admin; go to the Editing tab, and enable editing temporarily; copy "MySQL table name for editing" and create a new table linked to an existing data source. There, choose MySQL, and use the query:
SELECT * FROM wp_wpdatatable_1
WHERE userid = %CURRENT_USER_ID%
Assuming the MySQL table name for editing is wp_wpdatatable_1. This filters the table, so it always shows the values of a currently logged in user, using placeholder %CURRENT_USER_ID%.
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