How can I query all the subtask of a specific type regardless of parent?

[Alexandra Moraru]

Hello, 

I am trying to pull a list of all subtasks of a specific type (we use 6 types of subtasks) across all projects in a specific time frame? My ultimate goal is to calculate average time from assigning a subtask to completing it, but I cannot seem to find a way to pull the list of the subtasks.

Thanks in advance!

[PADMA KOTHAKOTA · Accepted solution]

Hi ,

I think you can use the below filter  it will list  out all the sub-task issue type issues 

issuetype  in subtaskIssueTypes()

[Alexey Matveev · Accepted solution]

Hello,

I think your JQL query would look like this:

issuetype = <your subtask type>

[lukec]

I wanted to find all the issues that were using the Sub-Task of "Performance Test".. so I used the above and just added a little to it:

issuetype in subTaskIssueTypes() and issuetype = "Performance Test"

This way I can narrow down only see the one Sub-Task I want. 

[Panos Rigopoulos]

I am trying to do this exact thing but this isn't working for me