Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
"Table Name_Column" = "value1" and "Table Name_Column" = "value2"

Column Type

Supported operators

Functions

Keywords

Simple Text

~ , !~ , is not , is

EMPTY

Number

= , != , <= , >= , > , < , is not , is , not in , in

EMPTY, ORDER BY (ASC / DESC)

Decimal Number

= , != , <= , >= , > , < , is not , is , not in , in

EMPTY, ORDER BY (ASC / DESC)

Date

= , != , <= , >= , > , < , is not , is , not in , in

currentLogin(), endOfDay(), endOfMonth(), endOfWeek(), endOfYear(), lastLogin(), now(), startOfDay(), startOfMonth(), startOfWeek(), startOfYear()

EMPTY, ORDER BY (ASC / DESC)

Select List

= , !=, is not , is , not in , in

ORDER BY (ASC / DESC), EMPTY

User Picker

= , != , is not , is, not in, in

EMPTY, ORDER BY (ASC / DESC)

Checkbox

= , != , is not , is, not in, in

unchecked, ORDER BY (ASC / DESC)

Info

Formula field is not available for the JQL search.

Operators

  • =

  • !=

  • ~

  • <=

  • >=

  • >

  • <

  • is not

  • is

  • not in

  • in

...