Find parent issues that are closed while all their sub-tasks are not Closed status

Suresh.Kumar June 7, 2021

Find parent issues that are closed while all their sub-tasks are not Closed status.  i am using https://mydomain.atlassian.net/

1 answer

1 vote
Hyrum Steffensen _Appfire_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 7, 2021

Hello Suresh,

Getting the parents of subtasks using JQL is not supported out of the box. You must use a plugin such as Power Scripts or Scriptrunner using Jira Server or Data Center. Here is a JQL query I tested using the parentsOf() routine using Power Scripts. 

key in parentsOf("issuetype = Sub-task AND status != Done") AND status = Done

For more information see this documentation on parentsOf().

Because of Confluence Cloud security features, you may need to open the documentation in incognito mode or by logging out of Confluence.

Full disclosure, I am a product engineer for Power Scripts and work for Anova Apps, an Appfire company.

Suresh.Kumar June 15, 2021

Can you suggest anyone of this i can use free extensions without buying

 plugin such as Power Scripts or Scriptrunner using Jira Server or Data Center

Like Andreas Link likes this

Suggest an answer

Log in or Sign up to answer