You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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.
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)")
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.
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.