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; } } }

extract issues in epics

unknown

We want to extract issues which are part of epics in csv/excel

We are using field linked issues under column and it is not displaying the issues which are part of it.

Can you please advice which field is to be used so it gives the issues in epics

Thanks

Accepted answers

Ste Wright

Hi @[deleted]

I would advise searching in JQL for:

"Epic Link" is not EMPTY ORDER BY "Epic Link" DESC

Details below...

Epic Link is the field which shows the parent of a child issue
The first part of the query will find all Issues which have an Epic
The second part - ORDER BY - will ensure they are ordered per Epic
You can also add Epic Link as a column

If you're looking to have Epics and their children in the one list in order (i.e Epic then it's children, etc) - it's quite complex. I'd probably advise if you're exporting to CSV/Excel to export the Epic data and the Child data separately, then concatenate it after.

Ste

Dmitry Astapkovich _Colined_

This is one of the use cases we have covered in the Pivot Report. With our app you can easily get full visibility of all issues in the Epic(s), even if they are used in multiple project. Excel export is there as well:

You can check the demos listed on the Marketplace page or book a demo if needed (right bottom corner).

All comments

Ste Wright

Hi @[deleted]

I would advise searching in JQL for:

"Epic Link" is not EMPTY ORDER BY "Epic Link" DESC

Details below...

Epic Link is the field which shows the parent of a child issue
The first part of the query will find all Issues which have an Epic
The second part - ORDER BY - will ensure they are ordered per Epic
You can also add Epic Link as a column

Ste

unknown

Hi @Ste Wright :

Thanks for the answer

I want to see the issues which are part of epic

Epic link is not able to give me the list of issues which are in epic.

I am using Cloud

Can you please advice

Ste Wright

Hi @[deleted]

Epic Link is the field which should be populated on each child Issue (i.e the Issues in an Epic) - to show what the parent is.

If this isn't working - it could be either...

A data issue - check the Parent/Child relationship is correctly applied through Epic Link, rather than Linked Issues or similar
A Team-managed Project

If you are using a Team-managed Project, there's a slightly different JQL I'd use:

parent is not EMPTY AND issuetype not in subTaskIssueTypes() ORDER BY parent DESC

^ Parent is also then the field you need to add to the Columns.

Let us know if this works for you. I find it can sometimes be a little temperamental.

Ste

unknown

Hi @Ste Wright :

We are using company managed project.

When i search for an epic using JQL i want a column that can display issues within that epic

IPA-3337 ,IPA-3358 are part of epic IPA-3114

When i search for IPA-3114 i cannot see the issues under epic link

Hence not able to extract it

Please advise

epic issues.JPG Epic link blank.JPG

Dmitry Astapkovich _Colined_

unknown

@Dmitry Astapkovich _Colined_ : Thank you for the help ..will check the plugin

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud