nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Need to pull consolidated details of a single Jira issue in excel or word or pdf

Jenin CM

Hi All,

I need to pull details of a single issue in an excel or spreadsheet. Here is the problem, this issue has a list of epic links and linked issues. I need the details of all epic links, linked issues and other custom fields in the same report.

The problem is to get "Issues in Epic" details as well in the report:

Accepted answers

All comments

Jenin CM

MichałS

Do you mean by "Epic Link" the "Epic Link" from Jira Agile? Which version of JIRA are you using?

Jenin CM

Hi Michal,

Yes, Epic Links. Let me give you an example, lets say RTT-1 is an Epic and various issues in other projects for eg PUAT-1, PUAT-2, CC-1, CC-2 have RTT-1 as Epic links.

I need to pull a report for RTT-1, where I will have list of "Epic in Issues" along with other fields for this issue i.e RTT-1 in a single report.

My Jira Version is: 5.2.11

Jira Agile Version is: 6.3.2.1

Regards,

Jenin

MichałS

You can get the issues of an Epic with this JQL:

"Epic Link" = "RTT-1"

You can do also the same over the REST API to get the issues

Jenin CM

Thats something I am already aware of but my requirement is to get all the details of RTT-1 in a single report.

i.e Along with issues in epic we need to have all other details as well for RTT-1, like linked issues, fields etc.

If I export the issue RTT-1 to word I don't have "Issues in Epic" field in that.

mwarton

Hi Jenin,

Take a look at our plugin Intelligent Reports. It allows you to create a template in Word and then set up some point and click rules as to how you want the template filled in.

For this particular report, you can easily use the JQL query and any custom fields from other issues that you want.

Midori

Implement this report with the PDF View Plugin fairly easily.

The PDF output is generated from fully programmable and customizable templates, which support traversing links and getting field values from the linked issues easily.

Hints:

The default template already generates a list of linked issues, which could be a trivially good starting point for your work.
Another example to check is the traceability matrix export, which detects dependencies between issues by checking if there is a link of a certain type between them.