Filter Expressions

Filter Expressions

Filter expressions are an advanced way to filter reports, and this page describes how to write them. In the Explore section you can use them by adding a filter and choosing the matches (advanced) option.


FOOis equal to “FOO”, exactly
FOO,BARis equal to either “FOO” or “BAR”, exactly
%FOO%contains “FOO”, matches “buffoon” and “fast food”
FOO%starts with “FOO”, matches “foolish” and “food” but not “buffoon” or “fast food”
%FOOends with “FOO”, matches “buffoo” and “fast foo” but not “buffoon” or “fast food”
F%ODstarts with an “F” and ends with “OD”, matches “fast food”
EMPTYstring is empty (has zero characters) or is null (no value)
NULLvalue is null (when it is used as part of a filter expression, place NULL in quotes, as shown on the filters documentation page)
-FOOis not equal to “FOO” (is any value except “FOO”), matches “pizza”, “trash”, “fun” but not “foo”
-FOO,-BARis not equal to either “FOO” or “BAR”, matches any value except “FOO” and “BAR”
-%FOO%doesn’t contain “FOO”, does not match “buffoon” or “fast food”
-FOO%doesn’t start with “FOO”, does not match “foolish” or “food”
-%FOOdoesn’t end with “FOO”, does not match “buffoo” or “fast foo”
-EMPTYstring is not empty (has at least one character)
-NULLvalue of column is not null (when it is used as part of a filter expression, place -NULL in quotes, as shown on the filters documentation page)
FOO%,BARstarts with “FOO” or is “BAR” exactly, matches “food” and matches “bar” but not “barfood”
FOO%,-FOODstarts with “FOO” but is not “FOOD”
_UFhas any single character followed by “UF”, matches “buffoon”


Filtering on true or false type values requires you to know what type of true or false value you’re interacting with.

Table 25. BOOLEAN
yes or Yesfield evaluates to true
no or Nofield evaluates to false


Filters on numbers support both natural language expressions (for example, 3 to 10) and relational operators (for example, >20). The system supports the OR operator to express multiple filter ranges (for example, 3 to 10 OR 30 to 100). The AND operator can be used to express numeric ranges with relational operators (for example, >=3 AND <=10) to specify a range. Filters on numbers can also use algebraic interval notation to filter numeric fields.


The syntax for numeric filter expressions using NOT may not be intuitive. The examples below show how to use it.

5is exactly 5



is any value but exactly 5
1, 3, 5, 7is one of the values 1, 3, 5, or 7, exactly
NOT 66, 99, 4is not one of the values 66, 99, or 4, exactly
1, NOT 2is neither 1 nor 2
1, NOT 2, >100is neither 1, nor 2, nor greater than 100
5, NOT 6, NOT 7is 5, is not 6 or 7
5.5 to 10

>=5.5 AND <=10

is 5.5 or greater but also 10 or less
NOT 3 to 80.44

<3 OR >80.44

is less than 3 or greater than 80.44
1 TO


is 1 or greater
to 10


is 10 or less
>10 AND <=20 OR 90is greater than 10 and less than or equal to 20, or is 90 exactly
Share this Doc

Filter Expressions

Or copy link

In this topic ...