how do I create a query which includes tasks and subtasks of an epic?

[Mary Irion]

I wish to create a filter which will display a single epic of a project and the epic's tasks and subtask.  What is the correct equation?

[mauricio.groth · Accepted solution]

Hi @Mary Irion

I’m Maurício, a support engineer at Appfire and I’m here to help you.

Unfortunately, using JQL of Jira, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to display an specific epic’s tasks and subtask:

issue in childrenOfIssuesInQueryRecursive("issuekey=ABC-1”)

Please note that we have created a support ticket https://jqlsearchextensions.atlassian.net/servicedesk/customer/portal/2/SEARCH-1105 in our portal, and we request you to sign in to the portal and let us know the username so that we can mark you as the reporter so that you will be able to access the ticket. 

Please find the below link to signup to the portal: https://jqlsearchextensions.atlassian.net/servicedesk/customer/portal/2 

Looking forward to hearing from you! 

Thanks,
Mauricio

[Mikael Sandberg · Accepted solution]

You need an app that extends JQL in order to do this. JQL out-of-the-box cannot do a nested query that gets you this result. Check the Marketplace for apps that can do this for you.

[Mary Irion]

I have several apps.  Don't need them nested, just need to pull them into the query.  I think? one needs to use "parent of" or some such phrase?

[Mikael Sandberg]

Basic JQL can only pull a known parent and the issues that are children of it, something like this:

parentEpic in (JRA-123, JRA-456)