How can I generate a Jira report that includes the release version and its associated issues?

Roger Alexis Mosquera Montaño April 29, 2024

Hello

I need to generate a report from JIRA that shows a list of issues associated with a release version, including the current status of the release, the release description, and various fields of the issues such as key, summary, status, etc....

It is important that this report can be exported to an Excel file.

How can I create a report with these characteristics?

Thanks

3 answers

1 vote
Kalyan Sattaluri
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.
April 29, 2024

Hello @Roger Alexis Mosquera Montaño 

Unfortunately, there is no such report OOTB. You have to either use third party add-ons or integrate with Jira Rest APIs in Tableau / Power BI or Excel so you can customize your report.

Roger Alexis Mosquera Montaño May 27, 2024

Hello @Kalyan Sattaluri 

Thanks for the answer.

0 votes
Aron Gombas _Midori_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 30, 2024

You can do this by

First execute a query like this in the Issue Navigator:

fixVersion = "1.2.3"

Then select the columns you are interested in, and export the data set with Better Excel Exporter using the "Current fields" export type.

It will produce a standard Excel spreadsheet containing an issue list like this:

jira-issues-selected-fields.png

If you need the release meta-information (version name, description, etc.) then create a custom Excel export template for that. It should be rather straightforward, but please feel free to ask.

(Discl. it is a paid and supported app developed by our team. Free for 10 users!)

Roger Alexis Mosquera Montaño May 27, 2024

Hi @Aron Gombas _Midori_ 

Thanks for the answer.

I really need a report that can include multiple fix versions with their associated issues without having to specify a particular fix version.


Thank you very much.

0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
April 30, 2024

Hi @Roger Alexis Mosquera Montaño

you may already be aware of this, but you can receive the issues of a version using Jira's standard issue search, with a JQL clause like

fixVersion = <your fix version>

You should also be able to export these issues to Excel. This would not include the fix version name and details, but maybe that's something you could add manually?

Alternatively, if you're open to solutions from the Atlassian Marketplace, you'll likely find more optimised options there. As an example, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

With these, you can build a report like e.g. this in just a couple of clicks:

fix-version-report.gif

This is really just one of a virtually endless number of possible views and reports - you can also view, group by, and sum up any other field(s). Of course, your sheet can also be exported to Excel in just one click.

Any questions just let me know,

Best,

Hannes

Roger Alexis Mosquera Montaño May 27, 2024

Hi @Hannes Obweger - JXL for Jira

Thanks for the answer.

I really need a report that can include multiple fix versions with their associated issues without having to specify a particular fix version.


Thank you very much.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events