Operators for filter conditions

Analytics is now Insights

All of the Analytics capabilities of the app remain unchanged. You can continue using your existing dashboards, charts, and smart links alongside the new Rovo-powered features. These features combine work and data context to provide reliable answers, create a shared understanding of data, and build dashboards that your team can depend on.

Read about this change

When you add a query filter or a filter condition to a “Filter rows” step, you’re presented with different operator options depending on the column’s data type.

Filter operators for string data types

Operator	Description
=	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

Filter operators for number data types

Operator	Description
=	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

Filter operators for datetime data types

Operator	Description
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

Filter operators for boolean data types

Operator	Description
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

Filter operators for array data types

Operator	Description
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

Was this helpful?

It wasn't accurateIt wasn't clearIt wasn't relevant

Still need help?

The Atlassian Community is here for you.

Ask the Community