Join in JIRA - Want to select a column from the linked issue

To manage our Epics and Stories, we are using the link functionality. I'd like to be able to select all Stories that are linked to ANY Epic. This is not difficult using the linkedIssues function. However, I'd like to be able to select the name of the Epic in the results so I can export to Excel and report on the progress. Can someone please suggest a way to do this?

Thanks in advance!

1 answer

1 vote
Renjith Pillai Community Champion Feb 04, 2013
  • Use Issue Navigator and use the JQL "Epic Link" = <<EPIC ISSUE ID>> - If you are using GreenHopper's builtin Epic capabilities
  • If you are doing some manual linking of isues use the JQL - issuekey in linkedIssues("EPIC ISSUE ID")
Renjith Pillai Community Champion Feb 05, 2013

Then, add a scripted field(s) for the story that shows the Epic title ad Summary and they do a JQL using that field

I am not using the build in Epic functionality. We started creating Epics much before they were intoduced in JIRA. So Epic is just another issuetype for us. The second response does not meet the requirement because I want my view to show Epic and Story in the same row. For example,

Epic JIRA ID - Epic Summary - Story JIRA ID - Story Summary - other Story fields.....

Is there a way to get the output in this format. It's OK to have Epic repeated because there may be many Stories for a given Epic.


Thanks! This makes a lot of sense but when I go to Custom Fields area, there is no option to pick a Scripted Field as indicated in the link you have provided. I checked to make sure that we have the Script Runner plugin installed and enabled. Am I missing something?


Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,296 views 14 20
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot