Automation for updating the numerical Value of a field based on child issue condition.

Drew McLean_0y3yc4

Hi,

This may not be a functionality that is possible but I want to check with others. 

I have a numerical field on a Parent Epic that is used to keep track of the number of stories in the 'To Do' status category.

I want to create an automation that, on manual trigger, will check the status category of the stories, and if it falls into the 'To Do' status category to increase the value of the field on the Parent Epic.

So 6 stories in 'To Do' results in Parent Epic field = 6.

I know I can do this in code but not sure if this is possible in Jira Automation.

Trudy P Claspill

Hello @Drew McLean 

Yes, this is possible with an Automation rule. Here is the rule:

1. Trigger: Manual

2. Use a Condition to confirm the rule was triggered on an Epic.

3. Use a Lookup Issue action to look for all child issues of that Epic where the child issue is a standard level issue type and its current status is within the "To Do" status category.

4. Edit the Epic to set your field to the count of issues found by the Lookup Issue action, or to zero if the action did not find any issues. (I used the Summary field but you would set your custom field.

Information about each of these functions can be found in the documentation.

https://support.atlassian.com/cloud-automation/docs/jira-cloud-automation/