List epics and their linked issues of specific type

[pat d-o]

Hi,

I'm creating an AIO report, in which I need to list all the epics in a particular project to which there are linked issues of a specific type (let's say, "My Task"). I need specifically the following view:

• Epic 1
  • My Task 1
  • My Task 2
• Epic 2
  • My Task 3
  • etc.

The filters applied in this AIO report seem to filter only by the epic and not by its linked issues, so currently, I get the list of all the epics and all their linked issues of all types. 

Can you please suggest any solution for showing only specific issue types that are linked to these epics?

Thank you!

[Tarun Sapra · Accepted solution]

Hello @pat d-o 

It's not supported out of the box, but via paid plugins like Script runner, you can do following JQL queries.

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_epicsof

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_issuesinepics

[pat d-o]

Thank you @Tarun Sapra It seems that this is exactly what I need!

take care

pat

[Tarun Sapra]

Hello @pat d-o 

If you find the answer useful, please accept/upvote so that others are also helped