JQL Query- for Parent task closed and sub task open

[Swati Sharma]

Need solution for :

PFD = closed(PFD is parent task)

and all sub task open

tried below

project = "PFD" AND (type IN("PFD Request") AND status = Closed)

and type in ("Sub-Task ROM Estimate", "Sub-Task COM Estimate", "Sub-Task Testing")

and status in ("Awaiting Sign Off", "Being Assessed", "For Impact Assessment", "In Allocation", "In Analysis", "In Validation", New, "Not Assigned to Tech", "On Hold", Open, "Pending PO Approval", "Pending Requester Sign off", "Request Review")

ORDER BY created DESC

but not getting result, please assist

[Bill Sheboy]

Hi @Swati Sharma 

That is not possible with the built-in features of JQL.  It could be performed with a marketplace addon to extend the features of JQL, or in several steps, using the results of one query to build the next one manually.

You posted this question in the Automation area.  Are you trying to perform such a query in an automation rule?  If so, the manual combining of queries I noted could be done with an automation rule.

Kind regards,
Bill

[Dexter de Vera]

Hi @Swati Sharma ,

Getting the parents of subtasks / subtasks of parents using JQL is not supported. You must use a plugin such as Power Scripts or Scriptrunner.