How to calculate the sum of original estimates[days] of all issue types to an Epic using Automation

[Paola Lops]

Hi Everybody,

I've already seen all the proposal and solutions proposed by the community about the topic in the question field but they don't work in my Jira plan. I don't know if I have some limitations due to Jira version but really I don't find a solution to this basic staff.

Just to explain better: I would like to define an automation that simply sum the effort of stories, tasks and sub-tasks into the epic field original estimates[days] as shown below.

Could someone give me some support?

Many thanks,

Paola

[Bill Sheboy]

Hi @Paola Lops -- Welcome to the Atlassian Community!

You describe you have "seen all the proposal and solutions proposed by the community about the topic in the question field but they don't work".

What have you tried thus far to solve this need?

If you have an automation rule which is not working as expected, please provide the following:

• what type of project you are using,
• an image of your complete automation rule, in one contiguous image,
• images of any relevant actions / conditions / branches,
• an image of the audit log details showing the rule execution, and
• explain what is not working as expected, and how you know it is not working that way. 

Those will provide context for the community to offer ideas.  Thanks!

Kind regards,
Bill

[Paola Lops]

Hi @Bill Sheboy ,

Thanks for your answer!

I am trying to apply the sum of original estimates of several stories to the relative epic in the original estimate field.

The requested info:

- project in Jira v9.4.18

- the snapshot of the used automation rule

- in the audit log, it is visible the config change but the operation of the rule is not visible and I don't know why. There is an info about the project audit log but I don't find it.

Many thanks for the support, this is really my first experience with that.

BR,
Paola

[Bill Sheboy]

Thanks for that information, and please stay with one thread when responding.  That will help others in the future looking at this question to know if there are multiple solution approaches.

You are using Jira Server or Data Center version of automation.  The Lookup Issues action for those does not support the time tracking fields yet.  Here is the suggestion to add the other fields: https://jira.atlassian.com/browse/JIRAAUTOSERVER-877

As you want to update the parent issue, there is only one workaround possible:

• remove your Lookup Issues action
• use the Send Web Request action to call the REST API for an issue search, using the JQL previously used with the lookup
• the web response issues may then be summed, as would the lookup

If you want to try this approach, here are some references to help:

https://community.atlassian.com/t5/Jira-articles/Automation-for-Jira-Send-web-request-using-Jira-REST-API/ba-p/1443828

https://docs.atlassian.com/software/jira/docs/api/REST/9.13.0/#api/2/search-search