Do we have a query which can fetch all the releases in Jira projects

[Mahant Madiwal]

Hi Team, We need a JQL query which can give us all the releases in Jira dashboard. Could you please help me out on this? 

It could be much appreciated.!

Thanks in advance.

[Walter Buggenhout _ACA IT_ · Accepted solution]

Hi @Mahant Madiwal ,

JQL queries in Jira search for issues, not releases. However, if you search for all issues (that would just be an empty search, with no criteria at all), you can use the output to visualise those issues per release.

You may e.g. use a pie chart gadget where you use fix version for the pieces of your pie. Or maybe even better: the two dimensional issue statistics gadget, where you can use fix version and project as your X and Y axes. As releases are specific to projects, that would make sense.

Obviously, you can always use a subset of all issues to do this as well, as fetching all issues from your instance to display on a dashboard may cause a bit of load on your instance. Depends how big your data set is, of course.

[Mahant Madiwal]

Hello @Walter Buggenhout _ACA IT_ ,

Thanks for your quick and valuable reply. This two dimensional issue statistics gadget worked for me which helped to meet our expectations.

[John Funk]

Hi @Mahant Madiwal - Add an Issue Statistics gadget to a dashboard.

Use the filter used by the board.

Then put Fix Version in the Statistics field.