Custom JQL functions

Release Management App goes with a number of custom JQL functions, namely

“fixVersion in ..“ JQL functions

The below functions returns only a list of fixVersions managed by Release Management App. Virtual versions are not returned!

Function

Description

Function

Description

versionsOfReleasesByName ("Board Name", "Release name")

Returns versions of cross-project release by release name

versionsOfReleasesByStatus("Board name", "Release status")

Returns versions of cross-project release by release status (column or workflow step)

versionsByStatus("Board name", "Version status")

Returns versions by version status (column or workflow step)

versionsOfReleaseByTagInBoard("Board Name", "Tag name", “Optional: Tag name2“,…)

Returns versions from a board by tag(s). At least one tag has to be specified. Optionally, the user can specify multiple tags. In that case, the function will return version which has ALL specified tags (so, AND condition is used)

versionsByTags("Tag name", “Optional: Tag name2“,…)

  • the same as previous but versions will be returned across all boards where the current user has browse board permissions

versionsOfReleasesByName("Board Name", "Tag name", “Optional: Tag name2“,…)

  • Returns versions which belong to a release with tag(s). At least one tag has to be specified. Optionally, the user can specify multiple tags. In that case, the function will return version of release which has ALL specified tags (AND condition).

Let us provide few examples how the above functions could be used in real world scenario.

Find all issues which belong to releases in Done status

fixVersion in versionsOfReleasesByStatus("My Board Name","Done")

 

Find all issues which belong to a particular release

fixVersion in versionsOfReleasesByName("My Board Name","My Release Name")

 

Find all issues which belong to versions in "UAT" status

fixVersion in versionsByStatus("My Board Name","UAT")

 

Find all issues which belong to versions with a tag “Regulation“ across all the board

 

Find all issues which belong to versions which have tags “Regulation“ and “USA“ at the same time across all the board

 

Find all issues which belong to versions which have tags “Regulation“ and “USA“ at the same time in “Portal releases board“

 

Find all issues which belong to versions in the release which have tags “Regulation“ and “USA“ at the same time in “Portal releases board“

 

“issue in ..“ JQL functions (ver. 4.1.0+)

The below functions returns a list of issues that belongs to all versions managed by Release Management App. So, virtual versions are taken in account as well - both JQL based and Epic based.

Function

Description

Function

Description

issuesOfReleasesByName("Board Name", "Release name")

Returns all issues that belongs to cross-project release. I means all the issues will be returned from the versions (both fix versions and virtual versions) that comprises a cross-project release.

issuesOfReleasesByStatus ("Board name", "Release status")

Returns all issues of cross-project release by release status (column or workflow step)

issuesOfReleaseByTags("Board Name", "Tag name")

Returns all issues from all releases with a specified tag.

issuesByVersionStatus("Board name", "Version status")

Returns all issues of versions by version status (column or workflow step). Both fixVersions and Virtual Versions are taken in account.

issuesByVersionTags("Tag name")

Returns all issues from all versions with a specified tag, across all boards.