Operators for filter conditions

=

equals

!=

does not equal

is one of

equals one of the values in the specified list

is not one of

does not equal one of the values in the specified list

is null

does not contain a value

is not null

contains a value

like

• contains the string

• case sensitive

• can use SQL wildcards

is not like

• does not contain the string

• case sensitive

• can use SQL wildcards

matches regex

matches the specified regular expression

like (case insensitive)

• contains the string

• case insensitive

• can use SQL wildcards

not like (case insensitive)

• does not contain the string

• case insensitive

• can use SQL wildcards

=

equals

!=

does not equal

is one of

equals one of the values in the specified list

is not one of

does not equal one of the values in the specified list

is null

does not contain a value

is not null

contains a value

>

greater than

>=

greater than or equal to

<

less than

<=

less than or equal to

between and including

between the specified range, including the end value

For example, between and including 1 and 5 returns 1, 2, 3, 4, 5

between and including

between the specified date range, including the end date

For example, between 2020-06-30 and 2020-07-02 returns dates from 2020-06-30, 2020-07-01, and 2020-07-02

is

the exact specified date

earlier than

before and not including the specified date

later than

after and not including midnight on the specified date

between N and M interval before now

N is the start; M is the end; does not include M

Interval options: minutes, hours, days, weeks, months, years

Examples for between N and M days:

If today is 2020-06-04...

• between 0 and 2 days returns 2020-06-03, 2020-06-04

• between 0 and 3 days returns 2020-06-02, 2020-06-03, 2020-06-04

• between 1 and 2 days returns 2020-06-03

• between 1 and 3 days returns 2020-06-02, 2020-06-03

current interval

Interval options: day, week, month, quarter, year

Note that “week” is the current ISO week.

last N interval

last specified number of chosen interval; inclusive

Interval options: minutes, hours, days, weeks, months, years

For timestamps, subtracts N * 24 hours from the current timestamp

is null

does not contain a value

is not null

contains a value

is true

A boolean can have either a true or false value, where true is 1 and false is 0.

is false

is not true

is not false

=

equals

!=

does not equal

is one of

equals one of the values in the specified list

is not one of

does not equal one of the values in the specified list

is null

does not contain a value

is not null

contains a value

The operators below are only available when using the “Filter rows” step

>

greater than

>=

greater than or equal to

<

less than

<=

less than or equal to

contains

one of the values in the array is the specified value

does not contain

the array does not contain the specified value

contains one of

contains one or more of the values in the specified list

does not contain one of

does not contain one or more of the values in the specified list

is empty

does not contain any values

is not empty

contains values

is null

does not contain a value

is not null

contains a value