How to find sub tasks within all open Epics

[Anisha Gallagher]

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_]

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 

[Anisha Gallagher]

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_]

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 

[KAGITHALA BABU ANVESH]

https://community.atlassian.com/t5/Jira-Software-questions/JQL-to-show-all-issues-AND-subtasks-in-the-Epic/qaq-p/346433 

look at the above thread. it may helpful

[Anisha Gallagher]

Thanks @KAGITHALA BABU ANVESH I had already seen that post but unless I've missed it, all the proposed solutions involve me having to define the epic link.

We use thousands of epics which are opening or closing on a frequent basis, therefore I do not want to define a set list of epic links. 

I want to find all Open epics and the sub-tasks within. I know that I'm effectively asking for sub tasks, within child tickets, with open epics so I may need an embedded jql query but I am not interested in the child tickets.