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

  • 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")

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 Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,124 views 4 9
Read article

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