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

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