Hi, Rainer 

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.

-

There can be different ways to achieve predefined filters for our tables.

-

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 someColumn = %VAR1%

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

then you can have multiple SQL Query-based tables that each have a different value filtered of that column.

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.

-

In terms of getting the currently logged user ID, we have this placeholder :

• %CURRENT_USER_ID% – this placeholder will be replaced with the ID of a currently logged-in user (if the user is logged in).

-

Let us know if that helped.  Thank you

-

@Sabri,

I am sorry but i don't understand your use-case.

Can you please check this documentation that shows all of our available Dynamic Placeholders for SQL Queries,

and let me know if that helps?

If not, can you please open a separate ticket about this subject and elaborate in more detail about your use-case,  and we will advise you if it is possible.

Thank you