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

[Michelle salas]

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! 

[John Funk · Accepted solution]

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. 

[Michelle salas]

Hi John, 

Thank you for your response. 

[Rahul_RVS]

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.

[Hannes Obweger - JXL for Jira]

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.

Hope this is useful,

Best,

Hannes