Get Results in Parent custom field based on Issue Type Status & customfield data

[Sunny Kumar]

Hi,
We are looking for an automation in DC where we can have value in Epic based on sum of child story point.

Thanks!

[Bill Sheboy]

Hi Sunny Kumar,

What version of Jira are you using: Cloud, Server, or Data Center?  The version you use impacts which automation features are available to do this summing for custom fields.

For Jira Cloud, the Lookup Issues action could be used with JQL to gather the issues and sum the field:

https://support.atlassian.com/cloud-automation/docs/jira-automation-actions/#Lookup-issues
https://support.atlassian.com/cloud-automation/docs/jira-smart-values-lists/#list.sum

Jira Data Center also has the Lookup Issues action, but it does not support custom fields yet.  Instead a rule would need to call the REST API issue search function with the Send Web Request action, and then sum the fields.  Please review this how-to article and function documentation to try that approach:

https://community.atlassian.com/t5/Jira-Software-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

Jira Server may use the same approach described for Jira Data Center.

Kind regards,
Bill

[Camilo Galleguillos]

Hi, Sunny!

This could be attached with JSU Automation Suite's post-functions, more specifically with the Calculated field option, which allow to make calculations based on the issue's children or related issues.

In your epic's workflow, you can create a looping transition (from any status to itself), and attach the calculated field post-function to it. 

[Sunny Kumar]

Hi Camilo, Thanks for the response, but we are looking to achieve this through JIRA Automation. Thanks in advance!