...
Use the following syntax:
”Table Name _Column” Columnname” = “value”
For example, the following JQL will show all issues that have the value "Services" in the Column "Element" of the table "Deal Positions".
...
Multiple values
| Code Block |
|---|
"Table Name_ColumnColumnname" = "value1" and "Table Name_ColumnColumnname" = "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 | = , != , <= , >= , > , < , is not , is , not in , in | EMPTY, ORDER BY (ASC / DESC) |