...
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" |
Operators
=
!=
~
<=
>=
>
<
is not
is
not in
in
Functions
...
currentLogin()
...
endOfDay()
...
endOfMonth()
...
endOfWeek()
...
endOfYear()
...
lastLogin()
...
now()
...
startOfDay()
...
startOfMonth()
...
startOfWeek()
...
Column Type | Supported operators | Functions | Keywords |
|---|---|---|---|
Simple Text | ~ , !~ , | ||
Number | = , != , <= , >= , > , < , not in , in | ORDER BY (ASC / DESC) | |
Decimal Number | = , != , <= , >= , > , < , not in , in | ORDER BY (ASC / DESC) | |
Select List | = , !=, not in , in | ORDER BY (ASC / DESC) | |
Status | = , != , not in , in | ||
User Picker | = , != , not in, in | ORDER BY (ASC / DESC) | |
Checkbox | = , != , not in, in | unchecked, ORDER BY (ASC / DESC) | |
Formula | = , != , <= , >= , > , < , not in , in | ORDER BY (ASC / DESC) | |
Date | = , != , <= , >= , > , < , not in , in | currentLogin(), endOfDay(), endOfMonth(), endOfWeek(), endOfYear(), lastLogin(), now(), startOfDay(), startOfMonth(), startOfWeek(), startOfYear() | ORDER BY (ASC / DESC) |
| Note |
|---|
The accuracy of the JQL results are affected by table context updates. For example, a table is set up to be displayed in both Story and Task issues, and it has values in issues of both types. If the Task issue type is then removed from the context, the JQL query will continue to list Task issues in the results. This occurs because the app stores table values in issue properties and they are not cleared after the context is updated. Adding a context filter to the JQL query, e.g. project = ABC, type = XYZ, easily solves the issue. |