There are three ways add a filter to a publication:
- Default where clause
- Shortcode parameters
- 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).
For security reasons parameter sql_where is no longer supported!
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.
To add a filter on a specific table column you can add an URL argument to your request that follows the following name convention:
This works for POST and GET request!
<input name="wpda_search_column_first_name" type="text" value="Sacha" />
first_name = 'Sacha'