Set a field value on a parent issue based on child issue status

[Ulrich Kone]

Hello,

We've created a custom field that we've put on tickets of type "Epic". We want to assign a value to it depending on the status of the child tickets in this epic (US - Tasks etc...)
We have tried this automation but it seems to be failing.
Could you please enlighten us?

[Bill Sheboy · Accepted solution]

Hi @Ulrich Kone 

Your rule is checking the {{lookupIssues}} smart value to evaluate all of the child issues of the Epic, but the rule has not used the Lookup Issues action first to load the issues.

Please add that action with the relevant JQL in order to use that smart value.

Kind regards,
Bill

[Ulrich Kone]

Hello @Bill Sheboy 

Thanks for your reply

Could you explain it more specifically please?

[Bill Sheboy]

To use the Lookup Issues action, create a JQL statement for the issues you need and used that with the action: https://confluence.atlassian.com/automation/jira-automation-actions-993924834.html  The set of issues may be used as a list.

It is unclear from your scenario if you need the lookup, but you are using it.  And so the Lookup Issues Action may be used before referencing the smart value.

An alternative for your scenario would be to only use the JQL condition or the Related Issues condition.  You are only checking the status of the child issues of the Epic, and not doing things like summing the values.  Please review those other conditions here:

https://confluence.atlassian.com/automation/jira-automation-conditions-993924794.html

[Marko Blagus · Accepted solution]

@Ulrich Kone,

Would you try doing it this way:

Of course, edit your conditions and add steps you need.

Let me know!

Best regards,

Marko Blagus

[Ulrich Kone]

Hello @Marko Blagus 

Thanks for you reply

Following your guidelines, the value of the custom field changes when a US/Task is closed despite the fact that there are still US/Tasks open in the Epic.

Whereas I only want to change the value when all the SUs/Tasks in Epic are closed.

Do you think there is a way to make it work properly?

[Marko Blagus]

Hello @Ulrich Kone,

You can add condition for epic to check if all other stories are done:

It will run for every issue under this epic and once all are done, it will edit the field.

Best regards,

Marko Blagus

[Ulrich Kone]

Hello @Marko Blagus 

Thank you verry much

It works perfectly

:)