Consolidate custom field value from all linked issues to current issue

Question

Dear all,

I'm writing an automation rule to sum up all the customfield values from all the linked issues to the current issue in CRBT project every 5 mins.

The customfield_12712(number field) is present on all the linked issues.

Lookup issues: I've written a query to list all the linked issues.

Edit issue: The current issue to be edited. The 'Consolidated CR' number field should populated consolidated value from all the values captured from 'customfield_1217'.

When the rule is executed, the auditlog shows sucessfull. It even shows all the available linked issues from lookup feature.

The current issue in CRBT project also shows edited.

But the Consolidated CR field value shows 0 in the issue despite the customfield_1217' filled in its linked issues.

Could someone review and advise if I'm missing something

Bill Sheboy · Answer

Hi @Samuel James

You are using Jira Data Center, and with that version only a limited number of fields are supported with the Lookup Issues action.  (There is an open suggestion to improve that.)

There are two possible workarounds, but for your case you want to update another field with the sum, and thus the REST API must be used.

Please see this post I added to an article describing how to solve this scenario: https://community.atlassian.com/forums/Jira-articles/How-Can-I-Sum-Up-Multiple-Issues-into-a-Parent-Number-Field/ba-p/2882712#M16701

Kind regards,
Bill

Ashish Gupta · Answer

Hello @Samuel James

Good Day!
You will need to add a branch for the linked issues to calculate the sum. It will be similar to the rule suggested in this article.

I hope this helps :)