Automation for Closed Epic with Open Child Tickets

Question

Hello,

I am trying to add a label using automation to issues where Epic is closed and still have Open tickets associated to it.

1. So far i have created a scheduled job, with a JQL Filter - Issuetype = Epic and status in ( Done, Closed)

2. Added a branch for stories and other issues in a Epic

*  (New Component) Added JQL as Status != Done
* Then Edit issue label and add a new label as "Closed Epic with Open Child Ticket"
* Unchecked issues that have changed since the last time this rule executed

The Automation was not successful and it was not updating the label to open child tickets in the Epic.

Adding screenshot for reference.

John Funk · Answer

@Manipal Reddy  - Did Bill's answer solve this for you?

Bill Sheboy · Answer

Hi @Manipal Reddy -- Welcome to the Atlassian Community!

Your rule is close to what you need, although I expect it is currently adding the label to the child issues, and not the epic.

You could modify your rule slightly to use the Lookup Issues action to identify the child issues which are open, and then add the label.

For example...

* trigger: scheduled with the same JQL you have
* action: lookup issues, using JQL to find child issues which are open; please update the JQL to match your configuration* parent = {{triggerIssue.key}} AND issueType IN (Story, Task, Bug) AND statusCategory != Done

* advanced compare condition: to check if there are any child issues meeting that criteria* first value: {{lookupIssues.size|0}}
* condition: greater than
* second value: 0

* action: edit issue to add the label to the epic

Kind regards,
Bill

A A Ron Geister _Trundl_ · Answer

In the Schedule you can add the JQL there. That might help with the execution of the automation. If its not in there already. I might make another recommendation here is to use the JQL for "resolution is EMPTY" rather then status or use: That should catch issue that do not have a resolution and are in the correct status. Please omit the <> that was just to show you the JQL. Hope this helps. Please let me know I can make some screenshot if you aren't following.