JQL Query- for Parent task closed and sub task open

Question

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 · Answer

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 · Answer

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.