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

[kyra.storm.van.leeuwen]

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.

[Jack Nolddor _Sweet Bananas_ · Accepted solution]

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

[Asha Gomez · Accepted solution]

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"))

[kyra.storm.van.leeuwen]

thank you! I will be exploring what plugin best suits us