All Epics with 100% Done filter to mark as done

Charles Wahab
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 16, 2023

Hello,

I am trying to search for all Epics that all child tickets are done and the Epic is 100% done, so I can mark the Epic status as done. 

It seems that the field progress is not searchable.

Much appreciated!

4 answers

1 vote
Mark Segall
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 16, 2023

Hi @Charles Wahab 

If you want the Epic automatically transitioned to Done when all children are Done, you could set up an automation rule like this:

  • TRIGGER: Issue Transitioned to Done
  • CONDITION: Issue Type not equal Epic
  • ACTION: Lookup Issues
    • "Epic Link" = {{issue.Epic Link}} AND status != Done
  • CONDITION (Advanced)
    • {{lookupIssues.size}}
      Less Than
      1
  • BRANCH: Epic (Parent)
    • ACTION: Transition Issue to Done
Charles Wahab
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 17, 2023

Thanks @Mark Segall - i'll give the rule a try!

Like Mark Segall likes this
0 votes
coolcodeiguess April 26, 2024

with Script Runner:

NOT issueFunction in epicsOf("status != Done") 
0 votes
Stephen Wright _Elabor8_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 16, 2023

Hi @Charles Wahab 

Can I clarify if...

  1. You just want to locate all Epics which have done children (no automated transition)? Or...
  2. You want the Epic to auto-transition when all children are Done?

---

(1) Find Issues

This isn't possible using native JQL, as it does not support sub-querying (i.e find Epics based on logic at the Children level) - your options are either...

  • Automation: Use Automation to populate a field at the Epic-level, which you can refer to using native JQL
    • Create a Custom Field to highlight when all child issues are "Done" - eg. a Checkbox Field
    • Use Automation to populate this Field, based on child Issues being transitioned, created, etc
  • App: Use an App from the Marketplace, which would provide the ability to use JQL sub-queries - for example...

---

(2) Auto-Transition the Epic

If you'd like to automate the Epic's transition, you could use Automation for this.

Mark has provided one option in another answer. The alternative is:

  • Trigger: Issue Transitioned
    • To Status = Done
  • Condition: Issue Fields Condition
    • Field = Issue Type
    • Condition = does not equal
    • Value = Epic
  • Branch: Related Issues
    • Type = Epic (parent)
      • Branch-Condition: Related Issues Condition
        • Related Issues = Stories (or other issues in Epic)
        • Condition = All match specified JQL
        • JQL = status = Done
      • Branch-Action: Transition Issue
        • Destination Status = Done

---

A few notes on the rule in (2)

  • This only checks the next level down - Story-level - it does not take into account Sub-tasks which might still be open below the Stories, Tasks, etc.
    • You'd need to consider how to handle this if required - eg. Post Functions to stop a Story being closed if it has an open Sub-task, automating the closure of Stories, additional Conditions in the above rule, etc.
  • You should also consider a Rule to reopen an Epic if relevant - i.e if a Story is reopened, or a new Story is added to a closed Epic - should the Epic reopen also?

---

Let us know if any of these options work for you :)

If you'd like more information, or detailed instructions for how to create the Automation Rules recommended in (1) or the notes for (2), also let us know so we can advise further!

Ste

0 votes
mauricio.groth
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.
January 16, 2023

Hi @Charles Wahab

I’m Maurício, a support engineer at Digital Toucan and I’m here to help you.

Unfortunately, using JQL of Jira, you’ll not be able to do it.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all your epics that have all the children as done or closed.

issuesInEpicCount > 0 and issue not in epicsOfChildrenInQuery("status not in (Closed, Done)")

Please contact our support if you have any other questions about this query. 

We’ll be happy to help you!
Best regards,
Maurício

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events