JQL for completed releases in JIRA

[Bharath Kumar]

Lets say I have releases 1.1 , 1.2 , 1.3 out of which both 1.1 and 1.2 are released, what is the JQL to show just the released versions.

So I need a JQL that returns only the released versions 1.1 and 1.2

[Jobin Kuruvilla _Adaptavist_ · Accepted solution]

You can use the releasedVersions function.

See https://confluence.atlassian.com/jiracoreserver073/advanced-searching-functions-reference-861257222.html#Advancedsearching-functionsreference-releasedVersionsreleasedVersions() for more details.

[Bharath Kumar]

thanks could figure that out

 But one small clarification I want to take this JQL and set it as a filter to show on dashboard the list of release that are completed. when i set this filter it shows all the issues that are from all the completed releases, like I mentioned in the example I just want to see the fix versions

[Jobin Kuruvilla _Adaptavist_]

You can probably create a filter using this and use it in a pie chart by selecting fixVersion as the statistic type? That will list all the released versions with number of issues in it.

You can do similar things with 2D Filter Statistic gadget as well.

[Bharath Kumar]

Thank you so much @Jobin for the help

The syntax for releasedVersions is releasedVersions(project) but when I try entering the project name it throws a error.

The JQL that I was using is fixVersion in releasedVersions(Online Ops)

[Jobin Kuruvilla _Adaptavist_]

Use double quotes if there is a space in the project name.

fixVersion in releasedVersions("Online Ops")

[Mike Ellertson]

What is the syntax for all version, released and unreleased?

[Mike Ellertson]

I found the answer to my question above.  Here is the syntax:

fixVersion in releasedVersions("Online Ops") OR fixVersion in unreleasedVersions("Online Ops")

[AtlassianLearner]

I'm trying to get all released and unreleased versions, hence using the below query which is throwing an error

jql = f'fixVersion in releasedVersions() OR fixVersion in unreleasedVersions()'

I tried filtering using some projects like below(as I need release information for multiple projects)

jql = f'fixVersion in releasedVersions() and project in ("sampleproject1","sampleproject2")

This is returning some records, but it doesn;t retrieve all the released versions I see on the browser

[Julian Lopez]

You can alternatively use the Project Key without quotes, e.g. 

fixVersion in unreleasedVersions(SSI, TAB, MIR, BS, DL, EB, SE2020, SE2021, TST)