Query get all subtasks for a parent

[Mkurama]

Hi,

I just want to write a JQL query to get number of all subtasks for a parent.

Any solution?

[Mkurama · Accepted solution]

I already fix it by this code and it works with me:

import com.atlassian.jira.issue.IssueManager
import com.atlassian.jira.issue.MutableIssue
import com.atlassian.jira.component.ComponentAccessor

IssueManager im = ComponentAccessor.getIssueManager()
MutableIssue issue = im.getIssueObject("JOL-60")
def count = 0

issue.getSubTaskObjects().each{
count++
}

 Great thank you @Fabio Racobaldo _Catworkx_ 

[Rilwan Ahmed · Accepted solution]

final Searchsubtasks = "parent = JOL-60" 
OR 
String Searchsubtasks = "parent = JOL-60"

[Mkurama]

Thank you @Rilwan Ahmed for your response

[Fabio Racobaldo _Catworkx_ · Accepted solution]

Hi @Mkurama ,

you can use field parent to do that. Example :

parent = YOUR_PARENT_KEY_HERE

Through the above JQL, you will retrieve all subtasks associated to that parent key.

Hope this helps,

Fabio

[Mkurama]

Hello @Fabio Racobaldo _Catworkx_ Thank you for your quick response.

I tried it in script runner to run the query but it return 0.

[Fabio Racobaldo _Catworkx_]

you missed an equal and project key should be in uppercase.

parent = \"JOL-60\"

[Mkurama]

Unfortunately, It doesn't work. in my case

[Fabio Racobaldo _Catworkx_]

Please, could you try in search issues first and verify that it works?

[Mkurama]

Yes. It works in normal search but I want to get number of subtasks for a specific parent in Script Runner. Ho it would be?

[Fabio Racobaldo _Catworkx_]

Please @Mkurama , share your scriptrunner code in order to fix your issue

[Rabi Kiran Roka]

project = "Project Key" and parent =Parent Key ORDER BY created DESC

This Query helps from the Issue Lists