• Products
  • Documentation
  • Resources

Atlassian Analytics is in an early access program

Only people who are part of this invite-only early access program have access to Atlassian Analytics.

Operators for filter conditions

When you add a filter condition to a query or to the “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

Additional Help