JIRA Query for Sub tasks but show Stories

[Natasha Gillam]

Hi

What is the JIRA query to display stories under a particular EPIC when the sub tasks is in Progress and has a particular title or could be a label? 

[Ste Wright]

Hi @Natasha Gillam 

There isn't a native JQL function that does this, as it requires sub-querying - i.e...

• Stories which have a specific Epic Link - works in standard JQL
• But, the Stories must have Sub-tasks - sub-query
• And those Sub-tasks must have specific titles or labels - further sub-query

For the sub-querying, you'll need an App from the Marketplace, such as...

• JQL Search Extensions for Jira
• Scriptrunner
• ...or another App, see a further list here

You can then use sub-queries to do the above.

If you already have one of these Apps, let us know which one, and whether you use Jira Cloud or Server/Data Center, so we can help create the query with you :)

Ste