Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,296,431
Community Members
 
Community Events
165
Community Groups

How do I export JIRA projects and all assigned task and stories under the created epic?

How do I export JIRA projects and all assigned task and stories under the created epic? I am looking to pull the export in the same order as the tasks and stories display in JIRA. The following query was created " project = OLG2022 AND issuetype in (Epic, Story, Task) ORDER BY "Epic Link", Rank ASC" however, the query when set to export does not pull in the desired order. The stories and task are not listed under the assigned Epic. 

Please advise. 

Thank you! 

3 answers

1 accepted

0 votes
Answer accepted
John M Funk Community Leader May 31, 2022

Hi Michelle,

You are not going to be able to export in the exact order the issues appear on the board. There are a myriad of factors that go into that. And you can't combine RANK and another fields when using the ORDER BY function. You will need to do your sort after the export. 

Hi John, 

Thank you for your response. 

Like John M Funk likes this
0 votes
Rahul_RVS_Support Marketplace Partner Jun 02, 2022

Hi @Michelle salas 

If you are fine with a mktplace app, you can try out our plugin

The app allows to export your entire epic hierarchy in a CSV format,

 Issue Hierarchy Reports 

The app also provides sum up at each level for time spent and story points.

Epic Hierarchy - CSV Export.png

Hi @Michelle salas

as John said, I don't think that "native" Jira and JQL can do that. You will need a view that understands parent-child relationships within Jira. 

Two possible ways forward:

First, I haven't used Advanced Roadmaps in a while, but IIRC, I "defaults" to showing issues in their hierarchy, and within this hierarchy, ordered by rank. I'm not sure if there's an export function, though.

Second, there's a number of hierarchy-focused apps in the Atlassian Marketplace. I can only speak for the app that my team is working on - JXL for Jira - but in JXL, it's as simple as this:

  • First, make sure that the "rank" field is added to your JXL sheet, and then sort by the rank. That's a one-click action.
  • Second, enable the default issue hierarchy. That's another click.
  • Lastly, export your view to Excel or CSV.

hierarchy-rank-order.gif

Hope this is useful,

Best,

Hannes

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...

14,549 views 37 45
Read article

Community Events

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

Events near you