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 _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".
"Deal Positions _Element" = "Services"
Multiple values
"Table Name_Columnname" = "value1" and "Table Name_Columnname" = "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) |