Hi Martin,

Thank you for your purchase.

Sorry for disappointment, but something like this is not possible with built-in features of plugin.

Unfortunately, at the moment we don't have available developers which can do this customization for you, because there is a lot of priority task that have to be done.

Thank you for understanding.

It probably can be done with some custom work, but our developers are very busy at the moment, working on some priority tasks and fixing bugs and issues with our plugins, so they won't be having the time for custom work in near future.

But we can recommend these services for customization:

https://codeable.io/?ref=l1TW1

https://wpkraken.io/?tms-plugins

They do develop such solutions, so can you please send your inquiry to them?

Thank you for your feedback, JN

There may also be a workaround available:

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.