Compare Operators

You use compare operators in the $FILTER command.

Operator Meaning Examples
= Equals priority = high
> Greater than risk > 50
< Less than number of days < 30
>= Greater than or equal to risk >= 75
<= Less than or equal to total time <= 10
<> Not equal to owner <> asmith

Use for string or other types only

LIKE Matches a pattern name like %xxx%

Use for string or other types only

NOT LIKE Does not match a pattern

tag not like ‘BR’

Use for string or other types only

BETWEEN _ AND_ In a range limit between 10 and 50
NOT BETWEEN Not within a range total not between 5 and 10
IN In a set number in (‘1,2,3)
NOT IN Not in a set serial not in (88,89,90)