Pre-filtering tables through URL

Video versionA video overview of search/filter tables via URL in wpDataTables

Search/filter tables via URLHow to set filter values through page URL address

If you want to open the tables pre-filtered by some specific value; for example, if you would like to create one table, but open it by several links pre-filtered by a specific value, you can do so by using a special URL key.

As an example, this table will be pre-filtered with ‘and‘ if you reopen this same page using this link.

To pre-filter the table just open the page adding a key to the url:

?wdt_search=filtervalue

Where ‘filtervalue’ is the value you would like to insert to the filtering field. This would pre-filter the table via global search. To see a quick video overview of this feature click here.

Defining column filter values in the URLSet individual columns advanced filter values through page URL address

You can also predefine column filter values for the table in the URL, which may come in handy. For example, when you want to send your client a deeplink with some info from your catalog that is already filtered for him. The URL key that will be parsed by the wpDataTables is “wdtColumnFilter[KEY]” where the KEY is either a zero-based numerical index of the column you want to filter, or an initial header of the column (header or the CSV or Excel table, or MySQL column header for MySQL-based column header), e.g.,

https://www.wpdatatables.com/documentation/table-features/global-search-via-url/?wdt_column_filter[1]=Linz

(see the URL part after “?” and check the table output)

The values parsed from this URL will be used as default filter values.

If you want to use it for range filters you will separate values with pipe (“|”). You can check that with this link below:

https://wpdatatables.com/documentation/table-features/global-search-via-url/?wdt_column_filter[3]=60|80

Passing Placeholders through URLPass placeholder values for filtering through the URL

Starting from wpDataTables version 6.4, you can pass values for our dynamic placeholders in the URL.

If you set a variable placeholder as a predefined column filter value for any table type or use it in a Query for an SQL Query-based table, you can pass or change the VAR1 value by appending it to the page URL:

?wdt_var1=your_value

To add multiple variables such as VAR1 and VAR2, separate them with an ampersand (&):

?wdt_var1=your_value&wdt_var2=second_value

Please note that any predefined filtering will not be possible to accomplish when using Cascade filtering logic from our Powerful filters Add-on.