Filter Comparing Operators
When building an advanced filter, each condition combines a column, a comparing operator, and a value. The operators available for a condition depend on the column's type, and the meaning of each operator may vary slightly depending on that type.
Operators Available by Field Type
* Displayed as Any = / Any Like / Any Match - matches when at least one element satisfies the condition.
* Displayed as All <> / All Not Like / All Not Match - matches when no element satisfies the condition.
Note: Person / Group columns appear in three filter variants - by login name, display name, or email address - but all three share the same set of operators.
Operator Semantics
Multi-value fields (Any =): matches when at least one element in the multi-value field satisfies the equality condition above.
The inverse of = for every field type. Matches rows where the column value does not satisfy the equality condition described above.
For Date/Time, when a day/hour/minute range is implied, <> matches values that fall outside that range.
Multi-value fields (All <>): matches when no element in the multi-value field satisfies the equality condition (every element must differ from the filter value).
Is Empty / Is Not Empty
Available for Date/Time columns only.
Like / Not Like / Any Like / All Not Like
Available for Text, Choice, and Person/Group columns. Pattern-based matching using the following wildcards:
If the filter value contains no wildcards, it is treated as a substring match: the operator matches when the column value contains the filter text anywhere within it. The comparison is case-sensitive.
Examples:
Not Like matches when the value does not satisfy the pattern.
Any Like (multi-value): matches when at least one element satisfies the pattern.
All Not Like (multi-value): matches when no element satisfies the pattern.
Match / Not Match / Any Match / All Not Match
Available for Text, Choice, and Person/Group columns. The filter value is interpreted as a full ECMAScript (JavaScript) regular expression. The match is case-sensitive by default; use an inline flag such as (?i) to make it case-insensitive where supported.
Examples:
Note: If the regular expression is invalid, the operator falls back to a literal string comparison (equal / not equal).
Not Match matches when the value does not satisfy the regex.
Any Match (multi-value): matches when at least one element satisfies the regex.
All Not Match (multi-value): matches when no element satisfies the regex.