JIRA: How to export (Excel) cards (Story, bug) and JOIN them ?

Question

I would like to list User Stories with some fields (like description, status,...) and the related bugs with some fields (description, status, assignee) and also the link property (like "is related to: ")

Using Jira 4.3.3

Is it possible though Jira? In another version 5.x? Or should I have to access tables with SQL?

Today, I am only able to export all issues with 1 cell containg the links.

But I don't know the property of this link.

If I want to show Bugs & related stories, I must join the 2 selections within Excel.

Example of question: List all Stories having with Status Open with all bug closed

Midori · Answer

You can solve this with the Better Excel Plugin and simplify getting this custom export to a single click!

How?

1. Set up the JQL query that returns the "unfiltered" list of stories (see the first part of your definition: "List all Stories having with Status Open...")

2. Then create an Excel template for the Better Excel Plugin which starts with executing a simple Groovy script. In the Groovy script implement a method that gets the list of unfiltered issues and returns the filtered list. You should be writing a one-line implementation of Guava's Predicate interface and then use Collections2.filter() method to apply that to input list. In other words, the predicate would capture the second part of your definition "...with all bug closed".

3. After you filtered the issues, just merge the filtered list into the Excel template. The plugin takes care of this for you.

That's all. If you have questions, we are happy to guide you more, just ask us.

Renjith Pillai · Answer

A direct export of Excel many not be possible.

What we did was to to dump the XML output of the required filter, (as issue links are not available with SOAP, I guess the same with REST too), define an XSD and auto generate classes for the XSD (Java or C#) and then dumped the data in whatever format we wanted.

And Jira CLI may will be of use.