Summing values from custom field into the parent issue with lookupIssues

[daniel_jones]

I need help.  I have searched and searched and found bits and pieces but am not able to figure out how to completely find a solution for my problem.

Any help/direction would be greatly appreciated.

Problem statement-

I am using Data Center v10.3.4

I have a custom field which is a number field type (customfield_10093) in all off my issue types (Epic, Feature, Story)

When that field is updated in a Story, I want to go to the parent Feature, then use lookupIssues get to the sum of that value in that field for ALL the child Stories in the Feature.  Then update the custom field in the Feature with the total of the values in all of the child stories

• Note that I can do this for a single story/feature combo so the smart values, logic, and edit work, but when I try to use the lookupIssues for multiple stories, it gives me a value of zero
• My suspicions
  • It for some reason is not returning a number, but  a text?
  • I have the sum config wrong somehow (although I researched this very thoroughly and don’t think so)
  • I just don’t know.

[Bill Sheboy]

Hi @daniel_jones 

With the lookup issues action and Jira Data Center, only a limited number of fields are supported, and they do not include custom fields.  Here is the suggestion to improve that: https://jira.atlassian.com/browse/JIRAAUTOSERVER-877

For your scenario to update another issue using a sum of values, the REST API must be used with the Send Web Request action.  Please look at this earlier post for additional details:

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

[daniel_jones]

Well first, thank you @Bill Sheboy  for such a prompt response.

I will read the articles, but I am much less comfortable with API/Webhooks than the built in automation so I may be out of luck.

[Bill Sheboy]

Once you get the first call working with Send Web Request, the remainder is list processing (like with lookup issues). 

If you want to give it a try and run into challenges, post images of your rule and audit log details so the community can help.

[daniel_jones]

screen shots forgot them