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

Question

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.).

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!

Bill Sheboy · Accepted Answer

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

Petru Simion [Simitech Ltd.] · Accepted Answer

@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.