Documentation Center

Attribute filter rules

Filter rules define the logic of attribute filters. 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.

A filter rule consists of the following:
  • A left operand (the Search In column): 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.
  • An operator (the Operator column): Creates the logic between the left operand and the right operands. 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).
  • One or two right operands, depending on the operator (the Search For column): The values to which the left operand is compared using the operator. The second right operand is available only for range operators.

You can combine multiple rules by 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.

Rules and restrictions

You cannot combine every attribute type (left operand) with every operator. You can find information about which operator types are available to which attribute type in the following table:
Attribute Type/Operator TypeEqualityComparisonRangeWildcard
Text FieldXXXX
Text AreaXXXX
SelectorXXXX
DateXXX
IntegerXXX
BooleanX
In addition, the following rules and restrictions apply:
  • Date-type attributes: When searching for Date-type attributes, the right operands must be in the mm/dd/yy or mm/dd/yy hh:mm formats (or the equivalent format for the regional settings you have selected). Wildcard operators (matches and not matches) are not supported for Date-type attributes.
  • Boolean-type attributes: When searching for a Boolean-type attribute, you must enter the string true in combination with the equals operator to filter the entries that have the Boolean attribute checked. To filter entries with the Boolean attributes unchecked, use the not equals operator with the string true in the right operand.
  • Wildcard operators: You can use the match and not match operators in conjunction with the wildcard * when filtering by attributes of the following types: Text Field, Text Area, or Selector . For example, the right operand values could be: ca*, *ar or *a*.
  • Created By/Modified By attributes: These default Text Field attributes contain information about the user who created or modified those entries. When an entry is created or modified in WorldServer, the values of these attributes are stored in the following format: 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, so you should use the matches operator is suggested. For example the right operand could be: *admin*.

Examples

Using these rules, you can create filters get information like the following:
  • To return all the entries created by this user for the last 10 days, configure the Created By and Created On fields.
  • To return all entries produced from the /doc/en/mydocument.html file, configure the Entry Origin field.