Hi, Nigel 

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.

-

Yes.  You should be able to achieve what you described,  it just depends exactly what the goal is, and i can advise you on possible ways to achieve it.

-

1. If you wish to filter the rows,  per  logged in user ID  ( Every user only sees the rows they make);

in that case, you would have to use either a Manual table,  on an SQL Query based table.

Please check out our feature on how to create Editable Tables in WordPress where users can see and edit only their own data here.

2.

But, if you simply wish to have one table,   that can be presented with different filtering on different pages,

then you can use our dynamic placeholder feature.

Please check out how they work here.

-

For example, if you have a column that you wish to use for filtering,

you can set a predefined filter value of %VAR1% ,

then for page 1,  you can set 

[ wpdatatable id=1 var1='Your_Filtering_Value_for_page_one' ]

and for page 2, you can set shortcode :

[ wpdatatable id=1 var1='Your_Filtering_Value_for_Page_Two' ]

-

Or if you use SQL tables, you can also use the Var placeholder in the Query.

Let me know if that is what you need, or if it might be something else,

please elaborate with more details , and i will advise

Thank you

Hi, Nigel 

Thank you for providing more details, i can see what you mean.

We don't have a built-in solution for this (yet); our developers with be working on adding it in the future, but i can't say an ETA on it, though.

At this moment, unfortunately, we can't create a solution as intended, in terms of one dynamic table having columns that can hide or show depending on a user role.

- The solution we can suggest for this functionality, is creating multiple tables on multiple pages.

You can have one main "source table" that holds all the data and columns. 

It could be a Manual type, or SQL based (has to be created in the database),   and then create separate tables from it by an SQL Query, each query can pull only the columns you need for a certain role. (an Admin can have access to the main/source table).

;

- In order to limit access to certain pages and tables, since wpDataTables can't do that, you can install a membership plugin, and set up which roles are restricted/allowed to view certain pages.

So, for example, if table 1 is for the Subscriber role, limit that page just for them, a second table just for editors, and so on; depending on what you need to achieve, which you can set up with a membership plugin.

- I hope that helps.

Let me know how that seems. Thank you.