Hello AJ

You can only use our "Users see and edit only own data" feature to do this, but I believe we could make it work. If the dependency is a user role, for example, we could make it work.

If I have this table:

This is a manual table which has manually entered IDs from wp_users and roles from wp_usermeta:

So, then I go to create an SQL query based table which will display entries based on user roles using this query:

SELECT  new_table.id AS ID,
        new_table.role AS Role,
        new_table.product AS Product,
        new_table.amount AS Amount
FROM wp_wpdatatable_6 AS new_table
JOIN wp_usermeta AS new_table_1
ON new_table_1.user_id = %CURRENT_USER_ID%
AND new_table_1.meta_value LIKE CONCAT('%', new_table.role, '%')

When I'm logged in with user ID = 1, I see this:

When I'm logged in with user ID = 4, I see the same thing. And when I'm logged in as one of the subscribers, I can only see the rows where role = subscriber:

The only difference is that as subscriber I don't have access to back-end, so this confirms it is working on both front and back.

So, we're only left with hiding unnecessary columns, adding names, and so on.

Hope this helps.

Hi Andrew,

Sorry for late response. 

We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.

Aleksandar is assign on our other products this week, so I will help you out.

Based on your explanation I can see that you turn on option User can see only data on table create from SQL query and that is the reason why you get those results. Please turn it off and you will get results like Aleksandar.

Please note that editing for this table will have issues or probably will not work because of the query.

Best regards.

Hi Andrew,

You are welcome.

I believe that you need to modify query to get results what you need.

If you have any other issue or question please open new ticket, and we help you out.

Best regards.