How to create a JQL query to obtain the list of releases?

Rafael Garcia Tamarit
Contributor
November 14, 2024

We have the Jira funcionality "Releases" that allows us to create releases and then use those releases to inform the field "fixVersion/s" in different ítems (Epics, Stories, etc.).

JIRA Releases.png

 

How to create a JQL query to obtain the list of "Releases"?

Which issuetype or ítem type should we use to find the existing "Releases" we have already created?

We would like to obtain that list of "Releases" and be able to export it to Excel (for instance) or include it in a gadget within a Dashboard.

Which fields or attributes has a "Release" item, so that we can refine the JQL filter to obtain the "Releases" of our insterest, for example, those having a certain tag  in its name?

Thanks in advance for any help!

2 answers

2 accepted

1 vote
Answer accepted
Petru Simion _Simitech Ltd__
Atlassian Partner
November 14, 2024

@Rafael Garcia Tamarit 

JQL only returns issues.

You can use CIFJ - Versions Dashboard for Jira, an app recently released by our company.

https://marketplace.atlassian.com/apps/1235582/cifj-versions-dashboard-for-jira?hosting=cloud&tab=overview

 

You can filter your search by projects, versions, start date from to, release date from to, archived and released.

You can export to CSV format.Screenshot from 2024-11-14 17-24-14.png

Rafael Garcia Tamarit
Contributor
November 15, 2024

Dear @Petru Simion _Simitech Ltd__ 

Thank you very much for your answer and information provided.

Kind regards.

0 votes
Answer accepted
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 14, 2024

Hi @Rafael Garcia Tamarit 

JQL queries return issues.  They do not return other Jira entities, such as versions.  Please look here to learn more: https://confluence.atlassian.com/jirasoftwareserver/searching-for-issues-939938681.html

To get a list of releases only, you could call the REST API endpoint to list the releases.  That could return the list of release for a project as JSON.

Kind regards,
Bill

Rafael Garcia Tamarit
Contributor
November 15, 2024

Dear @Bill Sheboy 

It is very clarifying knowing that JQL queries only return issues and they do not return any other Jira entities, such as versions.

Regarding the second part of your answer:
"To get a list of releases only, you could call the REST API endpoint to list the releases. That could return the list of release for a project as JSON."

My profile is not that of a software developer, so I don't know how to make a REST API call to get that JSON response, and how to use it to show the results in a gadget within a Dashboard. I wonder if that idea is feasible...

Thanks a lot for your answer.

Kind regards!

Suggest an answer

Log in or Sign up to answer