JQL to fetch open parents with all closed sub-tasks

[Manoj Gangwar]

I have Sciptrunner and tried many JQL's but still not getting correct result.

My requirement is When all sub-tasks are Resolved for a parent and parent status should not be Resolved.

I tried below JQL's

project = RQM AND issueFunction in parentsOf("status in (\"Open\", Pending, \"In Progress\") AND Resolution is Empty") AND issueFunction not in subtasksOf("status != Resolved")

project = "RQM" and issueFunction in subtasksOf('status not in (Closed, Canceled, Resolved)') AND Status = Resolved

This one is close enough but still fetching some parents which subtasks have pending status. 

[Manoj Gangwar · Accepted solution]

@Joseph Chung Yin 

I figured it out and below JQL works perfectly form me.

project = RQM and statusCategory != Done AND issuefunction in hasSubtasks() AND NOT issuefunction in parentsOf("project = RQM and status not in (Resolved)")

[Joseph Chung Yin]

@Manoj Gangwar -

Give this a try.

project = RQM and issueFunction in parentsOf("project = RQM and resolution is not empty") and resolution is empty 

This query should give you all the open parent issues where all of their subtasks are closed.

Hope this helps.

Best, Joseph

[Manoj Gangwar]

Still fetching the Unresolved Resolution subtasks for few parents. 

Query returned total 6 issues. 3 are correct subtasks are resolved and parent is not resolved but for rest of 3 subtasks are resolved, open, pending status and parent is not resolved.