1. Home
  2. Docs
  3. Index
  4. Data Publisher
  5. Adding filters

Adding filters

There are three ways add a filter to a publication:

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

Default where clause

The Data Publisher allows plugin users to add any default where clause to a publication (click image below to enlarge). This includes subqueries and other more complex filters. The default where clause also supports the $$USER$$ and $$USERID$$ environment variables to filter user specific data (user must be logged in).

Note

For security reasons parameter sql_where is no longer supported!

Shortcode parameters

Shortcode wpdataaccess provides 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:

[wpdataaccess pub_id="18" filter_field_name="lastname" filter_field_value="jose%"]

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

[wpdataaccess pub_id="6" filter_field_name="job,ename" filter_field_value="president,ford"]

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>

This works for POST and GET request!

Example

<input name="wpda_search_column_first_name" type="text" value="Sacha" />

Adds condition

first_name = 'Sacha'
Was this article helpful to you? Yes No

Leave a Reply

Your email address will not be published. Required fields are marked *