Hello there and thank you for reaching out to us.

If the value of a single cell is this:

['Environmental Sciences Master', 'Science, Technology, and Policy Master', 'Agricultural Sciences Master', 'Spatial Development and Infrastructure Systems Master', 'MAS in Sustainable Water Resources', 'Doctorate Environmental Systems Sciences']

That will be seen as a single value in wpDataTables.

You would need to manually define values within the column:

And that way, you'd be able to use it in the way you described:

I'm afraid there's no other way to achieve this.

Hi again Mathieu.

Unfortunately, the comma is a delimiter, and there's no way to include strings with multiple values separated by commas through the plugin. The only way you could implement it with the predefined values is through the database.

You'd need to access the wp_wpdatatables_columns table, find the ID of the table, and then identify the column that needs to include multiple values separated by commas. Then, you need to edit the cell related to this column in the "possible_values" (database) column, like this:

As they are separated with pipes in the database, you will be able to include commas:

As for your other question - that's something we call cascade filtering and it's available only with our paid add-on Powerful Filters. It changes the filtering options based on the previously selected filter. You can give it a go and even test it on our sandbox site before purchase to see if it will work for you.

Hi again Mathieu.

In your database, there are tables linked to wpDataTables. The "wp_" is the default prefix of WordPress database tables, but it could be anything on your end, so look for "your_prefix_wpdatatables_columns" table, where "your_prefix_" would be the same prefix you see for all database tables.

When you access this table, you will see a list of all columns created in wpDataTables, where you'll identify the column by the ID of the table and the name of the column. For example:

Scrolling to the right of this table, you'll see the "possible_values" column, that you need to edit:

Once you edit it, add all the criteria you need, separated by pipes | and it should work.