JQL Query for pulling all subtasks of a certain issuetype?

[Adrian Avalos]

Hello. Can someone provide a jql query for pulling all subtasks of a certain issue type? In my project Tasks and Stories issue types have subtasks and I'm looking for separate queries to distinguish them. I tried some of the below but no luck

issuetype = subtask AND PortfolioChildrenOf (issuetype = Story)

issuetype = subtask AND PortfolioChildrenOf (issuetype = Task)

issuetype = subtask AND Parent in (issuetype = Story)

issuetype = subtask AND Parent in (issuetype = Task)

[Pasam Venkateshwarrao · Accepted solution]

Hi @Adrian Avalos 

Welcome to the community,you cannot achieve this without Add-on. I can suggest you ScriptRunner or  JQL Search Extensions for Jira & reports 

 Here is the example how to get all sub tasks belongs to issue type story using  JQL Search Extensions for Jira & reports 

issue in subtaskOf("type= Story")

Hope this helps

[Bill Sheboy · Accepted solution]

Hi @Adrian Avalos 

What you describe is not possible with out-of-the-box features of JQL.

When you regularly need such types of queries, please investigate Atlassian Marketplace addons to JQL which support such nested querying.

Kind regards,
Bill