The filter rules define the logic of the attribute filter. A filter needs at least one rule and can have any number of rules. In the filter editor, a single rule is represented as one row in the rules table.
The attribute for which to filter. Choose the left operand from the list of all available attributes. The available attributes vary based on the filter type.
Creates the logic between the left operand and the right operand(s). The available operators can be grouped as: equality operators ("equals" and "not equals"), comparison operators ("less than", "greater than", "less than or equal to", and "greater than or equal to"), range operators ("between" and "not between") and wildcard operators ("matches" and "not matches").
Numeric ranges are inclusive. For example, if you had an Import Job ID range of 1001 to 1020, entries with an Import Job ID of 1001 and 1020 will be returned (as well as those between).
The values to which the left operand is compared using the operator. The second right operand is available only for the range operators.
Multiple rules can be combined using the rules operators. The available rules operators are the two Boolean operators: "and" and "or." When combining multiple rules using both of these Boolean operators, the "or" operator has precedence.
Add rules to the filter by clicking the Add Rule button. Delete rules by checking the box next to the rule(s) and clicking the Delete Rules button. To save changes to the filter, click OK.
Not every attribute type (left operand type) can be combined with every operator. The table below describes which operator types are available to which attribute type.
| Attribute Type/Operator Type | Equality | Comparison | Range | Wildcard |
|---|---|---|---|---|
| Text Field | X | X | X | X |
| Text Area | X | X | X | X |
| Selector | X | X | X | X |
| Date | X | X | X | |
| Integer | X | X | X | |
| Boolean | X |
In addition, the following rules and restrictions apply:
When searching for a Boolean type attribute, the string "true" must be entered in combination with the "equals" operator to filter the entries that have the Boolean attribute "checked." To filter entries with the Boolean attributes "unchecked," the "not equals" operator should be used with the string "true" in the right operand.
The "match" and "not match" operators can be used in conjunction with the wildcard "*" when filtering by attributes of type Text Field, Text Area, or Selector. For example, the right operand values could be: ca*, *ar or *a*.
These default Text Field attributes contain information about the user that created or modified those entries.
first_name <space > last_name <space > (user_name)
When the entries are imported from a third-party system, these built-in attributes may have different formats and information stored. Because of these formats and differences, the "equals" operator is not very effective, and the "matches" operator is suggested. For example the right operand could be: *admin*.