Index

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

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

The Data Projects tools allows plugin users to add any default where clause to a project page (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).

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:

[wpdadiehard project_id="8" page_id="43" 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:

[wpdadiehard project_id="6" page_id="31" 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 *

eight − 2 =