How write JQL to show orphaned sub-tasks

[Steve Josue]

We are using JIRA Datacenter 9.9.0

we recently added a workflow condition that won't all allow a parent user story to be closed if it still has sub-task children associated with it.

Is there a JQL query we can run to see if any sub-task children are currently orphaned? We are not having much luck writing such query.

Thanks in advance

Steve Josue

[Laurie Sciutti]

Hey @Steve Josue ~ do you use ScriptRunner?  If so, you could use the following function:

issueFunction in subtasksOf(<subquery>)

https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/sub-tasks#subtasksof 

[Steve Josue]

Hi Laurie -

We don't and now I wish we did.

I can't believe how many google results I got that absolutely do not work....

Thanks,

-Steve

[Danut M [StonikByte]]

Hi @Steve Josue,

What do you mean by an "orphan" sub-tasks? In Jira, every sub-tasks has a parent Story or Task, so you cannot have sub-tasks without a parent task. That's why I am asking...   

One way to do the visualization of stories and sub-tasks would be to use the Work Breakdown Structure (WBS) gadget offered by our Great Gadgets app. It takes the issues from a specified filter and displays them in a tree structure, by their hierarchy, in form of Epics > Stories, Tasks > Sub-tasks.

All you have to do it to have a filter that returns the issues to be grouped (Stories and sub-tasks in your case) and to configure the gadget to use this filter. Then, it will do the grouping for you.   

Please note that this app offers many other gadgets that you will find useful. Just have a look over the articles from our blog to make an idea. It can be a great asset for your team and company.

I hope this helps. 

Danut