Hey Everyone -
I'm trying to figure out why the column for 'Epic Name' is empty when I query stories in JQL. We're not using Next-Gen projects - so I've ruled that issue out. Anyone know how I can get this column to show the Epic Name? When I export my results, I want the name of the Epic to show in the csv. If I export the Epic Link, it just gives me a ticket number so I have to do a separate query to actually get the name for each of those linked Epics.
On Stories, you should use Epic Link field .
Epic Name is only populated on Epics elements and used as a label on the Epic Link dropdown on Stories. So there is no way to retrieve such information on CSV at Story level.
Thanks for you kind words.
Did my initial answer solve your doubts?
If so, consider to mark the proposed solution as an 'Accepted answer'. This will help other people with the same or a quite similar problem to find a solution in a easy and faster way.
In addition, by doing this the post will automatically gain the "Solved:" prefix in search results to indicate other people that no further support is needed.
You are correct that this cannot be done with standard Jira JQL queries.
I run into this same situation when exporting information to provide more advanced reporting than is available in out-of-the-box Jira. Here is what I do:
Automation for Jira allows you to automate actions - such as updating a field - based on a trigger event - such as an issue being created or updated.
This is how I did it using Automation:
As the text field has copied the text from the Epic Name, it'll be text rather than the Epic's issue key. This saves the manual steps in excel to join the text together.
The solution suggested by @Bill Sheboy is a good alternative though - if you don't have these apps or are unable to get them, this is what I would suggest also :)
I just added @Stephen Wright _Elabor8_ suggestion to our Jira instance and this is the updated instruction for the new issue view.
Hello Community! Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events