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

This widget could not be displayed.
  • 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
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

195 views 3 0
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