Is it possible to make the data in a table private to every user, but also let the admin see the data of all users? (But the rest of the users are not supposed to see each other's data)
Example:
People on my weigh-loss site would like to enter measurements every day. They are supposed to see only their own data, not anyone else's. But as admin, I need to see their progress, so I need to be able to see their measurements.
It is possible to allow users to see and edit their own data. You can find more information about it in our - Documentation. For admin to be able to see all the data from users you need to create one more table which will be MySQL query based table and will contain all the columns from previous table. So if you created manual table for users which creates table in your database called "wp_wpadatables_1" you will create MySQL based table from query
SELECT * FROM wp_wpadatables_1
and in it admin will be able to see all the data. We do have plans to develop option which will allow admins to see all the data in the same table in the backend in the near future.
Hi,
Is it possible to make the data in a table private to every user, but also let the admin see the data of all users? (But the rest of the users are not supposed to see each other's data)
Example:
People on my weigh-loss site would like to enter measurements every day. They are supposed to see only their own data, not anyone else's. But as admin, I need to see their progress, so I need to be able to see their measurements.
Hi billmondei,
Thank you for your inquire.
It is possible to allow users to see and edit their own data. You can find more information about it in our - Documentation. For admin to be able to see all the data from users you need to create one more table which will be MySQL query based table and will contain all the columns from previous table. So if you created manual table for users which creates table in your database called "wp_wpadatables_1" you will create MySQL based table from query
SELECT * FROM wp_wpadatables_1
and in it admin will be able to see all the data. We do have plans to develop option which will allow admins to see all the data in the same table in the backend in the near future.