Hello Shattv,

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

If I understood correctly, would you like to create a custom column that would act as "security level", and if a user who has a certain level, can see only the rows for tables/charts,  that are for that level.

Here is an example that we made, let's say if dependency for filtering rows would be a "user role" from WordPress users.

If I have this table:

This is a manual table that 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 a subscriber I don't have access to the back-end, so this confirms it is working on both front and back.

Now, I might have misunderstood you.

If you only need to filter rows for each user, for example, for user ID 1 , only show his rows, that is much easier to do.

We have a feature "users can see and edit only their own data".

You can take a look at it on this page, with a video and step-by-step example.

Let me know how that sounds, and if anything was not clear. Thanks.

Just wanted to point out that we have a sandbox/Demo site (https://sandbox.wpdatatables.com/), that you can use to try out some of the plugin's features;

and there is a 15-day money-back guarantee period, so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period.