Adding filters

There are three ways to add a filter to a Data Project

1. Default where clause
2. Shortcode parameters
3. URL parameters

Default where clause #

Shortcode parameters #

Shortcode parameters are available for shortcode wpdadiehard only. These parameters are not available for shortcodes wpdadataproject and wpdadataforms.

Shortcode wpdadiehard provides the following two parameters to filter data:

• filter_field_name (field name(s) to be filtered)
• filter_field_value (field value(s) to filter, performs a LIKE and therefor allows wildcards)

Example of a filter for one specific column:

For filters containing multiple column names and values, use a comma-separated value and make sure the array size of filter_field_name and filter_field_value are the same.

For example:

The filter allows to use % as a wildcard as shown in the single column filter example. These filter parameters do not support operators like IN, OR, NOT, >, < and so on. Please use the default where clause to use these operators and more complex filters.

URL parameters #

To add a filter on a specific table column you can add an URL argument to your request that follows the following name convention:

wpda_search_column_<column_name>

Example (GET and POST)

Adds condition

Wilcards are supported in URL parameters as well

IN conditions #

Use arrays to filter a column on multiple values (allows wildcard usage as well). For example:

Adds condition

OR conditions #

Use parameter wpda_search_column_operator to compare using OR instead of AND. The plugin uses AND by default.

Example AND (default) #

Adds condition

Example OR #

Adds condition

It is currently not possible to combine AND and OR conditions with URL parameters.