JQL Query for pulling all subtasks of a certain issuetype?

Question

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)

Bill Sheboy · Accepted Answer

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

Pasam Venkateshwarrao · Accepted Answer

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