Versions

The examples on this page describe how to build a JQL search using JQL Search Extensions.

On this page: 1 Versions JQL keywords 1.1 AffectedVersionsArchived 1.2 AffectedVersionsReleased 1.3 AffectedVersionsOpened 1.4 AffectedVersionsCount 1.5 AffectedVersionReleaseDate 1.6 FixVersionsArchived 1.7 FixVersionsReleased 1.8 FixVersionsOpened 1.9 FixVersionsCount 1.10 FixVersionReleaseDate

On this page: 1 Versions JQL keywords 1.1 AffectedVersionsArchived 1.2 AffectedVersionsReleased 1.3 AffectedVersionsOpened 1.4 AffectedVersionsCount 1.5 AffectedVersionReleaseDate 1.6 FixVersionsArchived 1.7 FixVersionsReleased 1.8 FixVersionsOpened 1.9 FixVersionsCount 1.10 FixVersionReleaseDate

Versions JQL keywords

AffectedVersionsArchived

Find issues with affected version archived.

Supported operators

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

Example

Find issues which affected version is archived.

affectedVersionsArchived > 0

AffectedVersionsReleased

Find issues with affected version released.

Supported operators

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

Example

Find issues which affected version is released.

affectedVersionsReleased > 0

Find issues in which no affected version is released.

affectedVersionsReleased = 0

AffectedVersionsOpened

Find issues with affected version opened.

Supported operators

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

Example

Find issues which affected version is opened.

AffectedVersionsCount

Find 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

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

Example:

Find issues that have affected versions.

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

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

Examples:

Find issues which affected version was released on the 13th or 14th of March, 2016.

FixVersionsArchived

Find issues with fix version archived.

Supported operators

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

Example

Find issues which affected version is archived.

FixVersionsReleased

Find issues with fix version released.

Supported operators

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

Examples

Find issues which fix version is released.

Find issues with no fix version released.

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

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

Example

Find issues with fix version opened.

FixVersionsCount

Find 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

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

Example

Find issues that have fix versions.

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

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

Example

Find issues which fix version was released on the 13th or 14th of March, 2016.