Single values
You can use an advanced JQL search to return issues with a specific value in a table column.
Use the following syntax:
”Table Name _Column” = “value”
For example, the following JQL will show all issues that have the value "Services" in the Column "Element" of the table "Deal Positions".
"Deal Positions _Element" = "Services"
Multiple values
"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) |
Formula field is not available for the JQL search.
Operators
=
!=
~
<=
>=
>
<
is not
is
not in
in
Functions
currentLogin()
endOfDay()
endOfMonth()
endOfWeek()
endOfYear()
lastLogin()
now()
startOfDay()
startOfMonth()
startOfWeek()
startOfYear()