extract issues in epics

[Ashish Saini]

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

[Dmitry Astapkovich _Colined_ · Accepted solution]

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).

[Ashish Saini]

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

[Ste Wright · Accepted solution]

Hi @Ashish Saini 

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

[Ashish Saini]

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 @Ashish Saini 

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

[Ashish Saini]

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

[Ashish Saini]

@Ste Wright : 

Thank you for the help 

I was able to extract

Thanks

Ashish