The instructions on this page describe how to execute a JQL search using JQL Search Extensions.
Versions JQL Aliases
AffectedVersionsArchived
Search for issues with affected version archived.
SUPPORTED OPERATORS
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
EXAMPLES
Find issues which affected version is archived
affectedVersionsArchived > 0
AffectedVersionsReleased
Search for issues with affected version released.
SUPPORTED OPERATORS
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
EXAMPLES
Find issues which affected version is released.
affectedVersionsReleased > 0
Find issues which no affected version is released.
affectedVersionsReleased = 0
AffectedVersionsOpened
Search for issues with affected version opened.
SUPPORTED OPERATORS
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
EXAMPLES
Find issues which affected version is opened.
affectedVersionsOpened > 0
AffectedVersionsCount
Search for issues with a particular number of affected versions.
SUPPORTED OPERATORS
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
EXAMPLES
Find issues which have affected versions.
affectedVersionsCount > 0
AffectedVersionReleaseDate
Search for issues which affected version was released on a particular date. This keyword works with date related JQL functions:
endOfDay()
endOfMonth()
endOfWeek()
endOfYear()
lastLogin()
now()
startOfDay()
startOfMonth()
startOfWeek()
startOfYear()
SUPPORTED OPERATORS
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
EXAMPLES
Find issues which affected version was released on 13th or 14th of March, 2016
affectedVersionReleasedDate = "2016/03/14" OR affectedVersionReleasedDate = "2016/03/13" affectedVersionReleasedDate in ("2016/03/14", "2016/03/13") affectedVersionReleasedDate < now()
FixVersionsArchived
Search for issues with fix version archived.
SUPPORTED OPERATORS
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
EXAMPLES
Find issues which affected version is archived
fixVersionsArchived > 0
FixVersionsReleased
Search for issues with fix version released.
SUPPORTED OPERATORS
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
EXAMPLES
Find issues which fix version is released.
fixVersionsReleased > 0
Find issues with no fix version released.
fixVersionsReleased = 0
FixVersionsOpened
Search for issues with fix version opened.
SUPPORTED OPERATORS
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
EXAMPLES
Find issues which fix version is opened.
fixVersionsOpened > 0
FixVersionsCount
Search for issues with a particular number of fix versions.
SUPPORTED OPERATORS
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
EXAMPLES
Find issues which have fix versions.
fixVersionsCount > 0
FixVersionReleaseDate
Search for issues which fix version was released on a particular date. This keyword works with date related JQL functions:
endOfDay()
endOfMonth()
endOfWeek()
endOfYear()
lastLogin()
now()
startOfDay()
startOfMonth()
startOfWeek()
startOfYear()
SUPPORTED OPERATORS
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
EXAMPLES
Find issues which fix version was released on 13th or 14th of March, 2016
fixVersionReleaseDate = "2016/03/14" OR fixVersionReleaseDate = "2016/03/13" fixVersionReleaseDate in ("2016/03/14", "2016/03/13") fixVersionReleaseDate < now()