Evoke Filter Operators

The build button on the Initial Filter Criteria takes you to the grid filter builder. Here you can define either simple or compound (multi part) grid filters.

Simple Filters

Simple Filters allow you to select a property, from the list of available properties in the entity property list and a value (either freeformat text e.g. "Pending" or from the drop down list of system values i.e. true, false, blank, empty). You can then use the filter operator to define if the property is to be equal to, less than, greater than, etc the value. Full details of the available operators may be found below.

Compound Filters

Compound Filters allow you to create a multi part filter criteria by joining together multiple simple filters. These filters will be joined either as "AND" or "OR". "AND" means that all simple filter tests must return true for the filter to allow the data item to be included and "OR" means that only one of the simple filters must return true for the filter to allow the data item to be included.

You should create each simple filter, within the grid, as above by selecting a property, from the list of available properties in the entity property list and a value (either freeformat text e.g. "Pending" or from the drop down list of system values i.e. true, false, blank, empty). You can then use the filter operator to define if the property is to be equal to, less than, greater than, etc the value. Full details of the available operators may be found below.

The + and - functions, in the header, allow you to add or remove simple filters and the elipsys menu allows you to nudge simple filters up or down the list.



Available Operators
Operator
Description
* or ] (as last char)
Starts with
* or [ (as first char)
Ends with
[ ]
Contains (case sensitive)
<
Less than
<=
Less than or equal to
>
Greater than
>=
greater than or equal to
To invert the result, prefixfilter value with '!'
To make content searches case insensitive, prefix value with '~'
To combine result inversion and case insensitive seach, prefix filter value with '!~'
Example#1: Age >= 18 Age greater than or equal to 18
Example#2: FirstName ] Jo FirstName starting with 'Jo'
Example#3: LastName!~[son LastName (case sensitive) not ending with 'son'


The initial Filter Criteria field can also include special Evoke system values. Special system values that can be used are:
"$index" For example, an initial filter setting of: $index < 5 will result in only the first 5 items in the root datasource being contained within the refined datasource (index values are zero-based). The =, >, >=, < and <= operators are supported for the $index property.