Hello AlI,

Thanks for showing interest in wpDataTables.

1. 

- 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.

-

2.

Setting a column to read-only can not be achieved by built-in functionalities, but here is a workaround with custom CSS, if you'd like :

For not allowing the customers to edit specific columns, you can include some custom CSS, like this:

input#noneditable {    pointer-events: none;
}

Where "noneditable" would be a custom CSS class added in column settings of any columns you don't wish to be editable:

So with this - if you enable these columns to also be editable, they won't be able to click on the edit box in the popup modal (similar to Master-Detail). It'd be better with the HTML attribute "disabled", but that would require a more complex code.

Please let me know if this custom CSS works for you.

3.

If you mean, to have something as a "global search", to search multiple tables at same time,

I am sorry to disappoint you, but currently, this is not possible to achieve with any of the plugin's capabilities. We might add it in the future, but I can't say an ETA. You can suggest this as a built-in feature on this link (https://wpdatatables.com/documentation/feature-suggestion/) and our developers would place it on their "TO-DO" list.

As more customers request a feature, it gets pushed quicker on the list. We always strive to make our product better and deliver the most value to our end users, so we carefully review each suggestion.

- You can also follow our changeLog page (https://wpdatatables.com/help/whats-new-changelog/) , 

where our developers state any changes/ new features/ bug fixes at each Update.