nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Accepted answers

John Funk

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.

All comments

John Funk

Hi Michelle,

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.