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:
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.,
(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:
It is also possible to pre-filter by individual columns. Click here to see a manual.
- Creating editable tables and filling the table data manually
- Creating non-editable tables from Excel files
- Creating non-editable tables from Google Spreadsheets
- Responsive design
- Conditional formatting
- Sorting tables
- Per-column filtering
- Row grouping
- Using Placeholders – Adjusting MySQL queries dynamically based on shortcode attributes
- Calculating totals for columns, sum row
- Table Layout, Word Wrap
- Table data export tools
- WPBakery Page Builder