Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL challenge - return all issues that are parents of sub-tasks having status = Done

Jack Brickey
Community Champion
June 30, 2017

I have sub-task issue type called Immediate Action. This is a temporary solution (sub-task) to the long term solution (parent). I want to add a gadget to my dashborard that shows all current temporary solutions that are awaiting the long-term solution. So something like this...

project = acme AND issuetype = "Immediate Action" AND status=Done AND parent-status != Done

so how to achieve the parent-status piece?

to make it more challenging.... without a plugin. :-)

1 answer

0 votes
Mirek
Community Champion
January 11, 2021

Ok, so if I understand correctly the goal here is to have some kind of view to show parents that have all sub-task resolved and probably quickly navigate and resolve the parent if required. 

Without the plugin? Oh yeah.. I like challenges.. Challenge accepted, @Jack Brickey ! :) 

I would personally be satisfied with Kanban View with set of Quick Filters and Swimlines configured.. 

In short.. 

  • Create a Kanban Board
  • Add a Quick FIlter with JQL (type in subTaskIssueTypes() AND resolution != Unresolved)
  • Set up Swimlines to group by Stories for example.. 

In a result I would get something like this where you can quickly and easily filter all parents tasks where all subtasks are done..  In addition you would get a magic button Move to Done that you can use to visually see which parents should be closed and simply when you want close them :) 

abc_01.png

All collapsed parents view (notice we see two Move to Done buttons without seeing Sub-Tasks)..

abc_02.png

Only show parents where Sub-Task are done (Quick Filter enabled),

abc_03.png

Expanded view when showing both.. 

abc_04.png

Hope it would help ;) 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events