JQL to Locate Sub-Tasks in a Parent Task for Dashboard in Jira

[Rodrigo Xavier]

Hello, everyone.

I am trying to find a way to locate all the sub-tasks of a specific "parent" task in Jira using JQL. I would like to create a JQL filter that allows me to view only these sub-tasks. This filter will be used for the creation of a dashboard.

Currently, I am using a JQL filter similar to the following for my queries:

project = "PROJECT_NAME" AND component in (Audit)) AND ((resolution = unresolved)) and summary ~ "SUMMARY"

I know it is possible to locate sub-tasks using plugins such as Advanced Roadmaps or ScriptRunner, which allow the use of the issueFunction clause in JQL. However, I currently do not have these plugins installed in my Jira instance.

Is there any other way to do this using only standard JQL, without the need for additional plugins? Any help or guidance would be very welcome.

[Trudy Claspill]

Hello @Rodrigo Xavier 

Do you want to get subtasks for a single, explicitly identified parent issue? Do you have the issue key for that issue? If so, then you can get the subtasks using the JQL:

parent=<issue key>

If instead you want to use a query like the one you posted to dynamically get a list of parent issues, and then get all the subtasks for those, that will not be possible with only native Jira functionality.

[Rodrigo Xavier]

Thank you very much for your help @Trudy Claspill . I had already done that, and it didn't work. It displays an error stating that I do not have permission or the issue does not exist.
But with your tip I managed to use parentSummary

project = "PROJECT_NAME" AND component in (Audit)) AND ((resolution = unresolved)) and parentSummary ~"SUMMARY"

[Trudy Claspill]

The error you received suggests that there may have been an error in how you wrote the JQL. Can you share the actual JQL statement you used?

[Rodrigo Xavier]

Exactly as you said @Trudy Claspill , I must have been typing something wrong, that's the only explanation.
Now the filter is as you mentioned.

project = "LPBR ICT" AND resolution = Unresolved AND component IN (Auditoria,IRM) AND parent = LPBRI-2488

Thank you very much again my friend.

[Trudy Claspill]

I'm glad I could help you 

Please consider clicking on the Accept Answer button to mark you question as Solved. That helps others searching for posts find the ones that have validated solutions.