Query to extract items under epics but also extract fields related to the items and the epics

[Juanita De Jong]

I want to extract epics with it's associated linked items under the epics. But the extract must contain fields from both the epic and it's items

The epics extracted will be based on a field that will give me a result of many epics (not just 1)

In English:

Give me all the epics where Fix Version = xxx AND the tasks linked to the Epic. List the status of both the Epics and the linked items, the assignee of both and list a field that only appears on the Epic.

Meaning I want 1 extract where Epic info & linked items info appear with 1 extract and I can use that in a pivot table, grouped by IssueType / Epic nu / items within that Epic with relevant statuses  

[Tarun Sapra]

Hello @Juanita De Jong 

I think to accomplish what you require you will need some help from a paid plugin like script runner or "custom field pack" to display from information about Linked Issues in the issue navigator view which you can then export.

Something like this

https://scriptrunner.adaptavist.com/latest/jira/recipes/misc/table-custom-field.html