How to find sub tasks within all open Epics

Question

I would like to find all sub tasks within all open epics without having to define individual epic names.

I can find all child issues using the query below but I need to take it a level lower in the hierarchy and return sub tasks instead.

issueFunction in linkedIssuesOf("issuetype = Epic and status != Closed")

Muhammad Ramzan_Atlassian Certified Master_ · Answer

Example mentioned by Kagithala is using the built features of Jira , the only drawback is you need to mention all links manually.

The above example which I mentioned is from JQL Search Extensions for Jira & reports plugin.

You can give a try of it or can you please confirm if you have any plugin , I will try to help you to design the query

Anisha Gallagher · Answer

Thanks @Muhammad Ramzan_Atlassian Certified Master_ I must have missed this example in the thread that Kagithala shared.

Unfortunately it looks the 'allissuesinepic' is not available with the current script plugin I'm using, I have 'issuesinepics' available but that only returns child tickets, not sub-tasks.

I'll look into script plugin options if it's not possible any other way.

Thanks again.

Muhammad Ramzan_Atlassian Certified Master_ · Answer

Hello @Anisha Gallagher ,

The current way of doing is same as suggested by Kagithala. I am not sure if you have any JQL or scripting plugins installed , if yes then you can achieve it by using them.

Let me give you an example of  JQL Search Extensions for Jira & reports, you may try if you are not able to achieve it using the built in queries

Following query will get all issues and sub tasks under epic where epic status is not closed.

issue in allIssuesInEpic("issuetype = Epic and status != Closed")

If you want to return only sub tasks under epics then you can modify it as below

issue in allIssuesInEpic("issuetype = Epic and status != Closed") and type=Sub-task