Hi, Michele.

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.

-

It depends on what is the original table type.

For example, if you have a Manual Table, just check in the Editing tab, "MySQL Table Name",

then you can easily call a new SQL Query table like :

SELECT * FROM Table_Name

You can add a "WHERE" SQL statement in the Query, like :

SELECT * FROM Table_Name

WHERE columnName= "REGION1"

And that will only pull the rows that are "REGION1" from your desired column.

There can also be different ways to pre-filter tables in our plugin :

If you wish to try Pre-filtering tables through URL,  please check out this page with examples.

-

You can also use placeholders for table generation.

1. For example, if you have a MySQL query-based table, you can use this query:

SELECT * FROM yourDatabaseTable
WHERE columnName = '%VAR1%'

%VAR1% can be defined in the Placeholders tab when you're creating a table, 

or you can pass VAR1 value in the table's shortcode.

-

For example if i have this Master Manual Table,

and i want to make a dynamic SQL Table with VAR1 placeholder.  ( Then later i can input different VAR1 in the table shortcode on different pages).

My example SQL Query for the table will be :

SELECT * FROM wp_wpdatatable_44
WHERE company = '%VAR1%'

First, just to initially generate an SQL table with the VAR1 ,

i will set the Cakewalk  company name in the VAR1 , in table's Placeholders tab :

-

Then, for example, if i want to make a different page for another Company,

 let's say "Adobe".  Then i pass that value in the VAR1 of the table shortcode :

2. 

Or, if you don't add the condition in an SQL query, you can add %VAR1% in column settings -> Filtering, under "Predefined filtering value".

Then, you can have different versions of the same table, with the VAR1 value passed in the shortcode,

let's say if we had a "Regions" column and we wish to filter a different region per each page.

If we want page 1 for example only filtered for "Region A" , you can set predefined filter to this column as %VAR1% (filter type has to be set as text) :

Then for a page where we need only Region 1 filtered, use shortcode [wpdatatable id=1 var1='Region A'] ,

 page 2 for only "Region B", shortcode would be [wpdatatable id=1 var1='Region B'] and so on, 

to apply the values defined in the shortcode to the filter.

( This filtering method can be used for any table type, besides Simple Tables)

-

I also made a short video example - please check it out here.

-

Let me know if that helps or if you have any additional questions.

Thanks.

Hi ,Michele.

My apologies, but i did not understand this use-case.

Could you please elaborate more on what is the current result,

and what will be the desired result, but if you can show us more details about your data set,

tables, etc;

if you can add some screenshots or even better record a Video that can summarize the use-case, 

then we can advise?

If the screenshots or Video have any sensitive data of your tables, please send them as "PRIVATE" reply, for security reasons.

Thank you.

Hi, Michele.

Can you try to add quotes around your searched value, like this :

SELECT * FROM tableName
WHERE region='Italy'

Let me know if this helps?

It works on my test table.