how to find sub-tasks belonging to a specific parent issue type

Question

We use 4 different issue types, Epics, Stories, Tasks and Sub-Tasks. I would like to find all sub-tasks that have a parent task [excluding Stories]

Note: I can find a lot of similar questions in the community, but when I click on one with the status: Solved and multiple responses, it returns 0 answers .. so have no clue.

Asha Gomez · Accepted Answer

Hi @kyra.storm.van.leeuwen

To get expected result ie, sub-task under parent issuetype it is better install scriptrunner plugin and try advanced JQL query like,

eg:

project=xyz AND "Epic Link" = issuekey-10 OR issuekey in (issueSubtasks("'Epic Link' = issuekey-10"))

Jack Nolddor [Sweet Bananas] · Accepted Answer

Hi,

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack (if you are on Server / DataCenter) you can type the following:

1) Find sub-tasks belonging to a specific parent issue (i.e Task of EMEA project)

issue IN subtasksOf(' type = Task AND project = EMEA ')

(*) Note that this is just an example, you must tune above query to fit your needs.

Using this app you can also query other issues relations, check:

* epicsOf()
* hasSubtasks()
* issuesInEpics()
* linkedIssuesOf()
* parentsOf()
* portfolioChildOf()
* portfolioParentOf()
* subtasksOf()

Regards