Filter Operator Reference for Reports


Field Type


Operator


Number

=

!=

>

<

>=

<=

is null

is not null

Date

Date Time

=

!=

>

<

>=

<=

is null

is not null


Date

Date Time

in the next

in the last

after next

older than


Value Set (Single)

=

!=

in

not in

is null

is not null

Value Set (Multi-Select)

=

!=

in

not in

contains

is null

is not null

Text, Long Text, Phone, Email,

=

!=

is null

is not null

contains

contains(ignores case)

starts with

ends with

Boolean

=

!=

Reference Field

Has any

Doesn’t have


Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us