How do I find all Releases for All Projects via JQL?

Question

We have multiple projects and each project has its own unrelated release and release dates.  We are looking for a query we can run that will list all releases from all projects that are not in a "Closed" state.  We don't want a list of open issues, we are looking for a list of the actual releases.  The kind of detail you get from the Release page of a Project.

The reason for this is so we can look at one page and see all releases in progress for all projects.

Is there a way to create a list of all open Releases across all Projects using JQL?

Kodi Terry · Answer

I don't mind copying and pasting this info to a spreadsheet, however, how do you get information about released - for a historical look?

unknown · Answer

I found the easiest way was to copy and paste from the Release list into a spreadsheet!

Jonny Adams · Answer

@Joe Did you have a chance to install and test the Jira Road Map gadget? It only shows projects that have not been released and it has a progress bar showing issues completed against total target issues for the release.

JQL is going to filter by issue, so if you do filter for something like fixVersion not in releasedVersions() and only show certain columns (ex: Fix Version and Status) you are going to see lots of duplicates.

You could create a webhook, using the previously mentioned JQL filter, that is triggered each time an issue is updated. That information can be sent in a JSON file which you could use to display details the way that you prefer.