nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SUM the values of 2 Number Custom Fields in a 3rd Custom Scripted Field (ScriptRunner)

Zita Bagi

I have 2 Number Custom Fields, let's say, they are called "11" and "22", and I want to display their sum amount in a 3rd custom field which is a scripted field.

I added the script below to the Script Field:

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.search.SearchProvider
import com.atlassian.jira.web.bean.PagerFilter
import com.atlassian.jira.issue.IssueManager;
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.issue.link.IssueLinkManager
import com.atlassian.jira.user.ApplicationUser

def issueManager = ComponentAccessor.getIssueManager()
def linkManager = ComponentAccessor.getIssueLinkManager()
def cfm = ComponentAccessor.getCustomFieldManager()

Issue issueKey = issue
def id=issueKey.getId()

def customFieldManager = ComponentAccessor.getCustomFieldManager();

def cf = customFieldManager.getCustomFieldObject("11")
def cff = customFieldManager.getCustomFieldObject("22")

def 1 = getCustomFieldValue(cf)
def 2 = getCustomFieldValue(cff)

def n = Integer.parseInt("1")
def b = Integer.parseInt("2")
 

if (n && b){
    def sumValue =  n + b
    return sumValue
}

In the console no error is displayed, but when I run it, I get an error log:

--------------------------------------------

2019-12-11 11:09:36,549 ERROR [runner.ScriptFieldPreviewRunner]: *************************************************************************************
2019-12-11 11:09:36,551 ERROR [runner.ScriptFieldPreviewRunner]: Script field preview failed for field that has not yet been created
groovy.lang.MissingMethodException: No signature of method: org.codehaus.groovy.jsr223.GroovyScriptEngineImpl.getCustomFieldValue() is applicable for argument types: (null) values: [null]
at Script906.run(Script906.groovy:67)

--------------------------------------------

Is this because I didn't manage to access the custom field value at all or as an integer? What would be the solution?

Thank you in advance!

Accepted answers

Zita Bagi

@Peter Garncarek

@Leonard Chew

So here is the version which now works for me. Replace id1 and id2 with your actual custom field IDs.

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.search.SearchProvider
import com.atlassian.jira.web.bean.PagerFilter
import com.atlassian.jira.issue.IssueManager;
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.issue.link.IssueLinkManager
import com.atlassian.jira.user.ApplicationUser

def issueManager = ComponentAccessor.getIssueManager()
def linkManager = ComponentAccessor.getIssueLinkManager()
def cfm = ComponentAccessor.getCustomFieldManager()

Issue issueKey = issue
def id=issueKey.getId()

def customFieldManager = ComponentAccessor.getCustomFieldManager();

def cf = customFieldManager.getCustomFieldObject(id1)
def cff = customFieldManager.getCustomFieldObject(id2)

def n = Integer.parseInt((issue.getCustomFieldValue(cf) ?: 0).toString().replaceAll(~/[.].*/, ""))
def b = Integer.parseInt((issue.getCustomFieldValue(cff) ?: 0).toString().replaceAll(~/[.].*/, ""))

Integer sum = (n ?: 0) + (b ?: 0);

All comments

Peter Garncarek

I had a similar challenge and found enough example to write this script for totaling many number fields. Change my field names to yours and see if it works. The fields are just number fields. You will see an error on def cf = line in editor but it works outside the editor.

I have this scripted field called "PPD Total Hours" which has this script.

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.CustomFieldManagerCustomFieldManager

CustomFieldManager customFieldManager = componentAccessor.getCustomFieldManager()

List<String> fieldNames = ["Mechanical engineering","mech engineering cranes & tools","mech engineering LCS","mech engineering ECH","mech engineering WRH","mech engineering WINCH","Electrical engineering","Documentation","Sales configurators & E2E","Product management","Product lifecycle management","Other"]

List<Integer> scores = []
for (String field : fieldNames){
def cf = customFieldManager.getCustomFieldObjectByName(field)
scores.add((Integer) issue.getCustomFieldValue(cf)?: 0)
}
return scores.sum {it}

Zita Bagi

Hi @Peter Garncarek ,

thank you very much for the comment! In the meantime I have actually received a solution from a different source.

I'm curios about your version too, so I tried it, but for the 2nd line I get an unable to resolve class error msg. I guess "CustomFieldManagerCustomFieldManager" is incorrect?

But if I change that to only "CustomFieldManager", I still get the error "the variable CustomFieldManager is undeclared"

Peter Garncarek

Error in the way I posted the code (my first time trying to do so). I am on Jira server 8.5.1 and latest version of Scriptrunner. I have corrected the original post to have this line

CustomFieldManager customFieldManager = ComponentAccessor.getCustomFieldManager()

This is the way it looks in my script window. I do not know why I see the error but the script works.

Zita Bagi

Thanks, I have it like this now, and I get "The variable [issue] is undeclared". How would I declare / import it?

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.CustomFieldManager

CustomFieldManager customFieldManager = ComponentAccessor.getCustomFieldManager()

List<String> fieldNames = ["1","2"]

List<Integer> scores = []
for (String field : fieldNames){
def cf = customFieldManager.getCustomFieldObjectsByName("3")
scores.add((Integer) issue.getCustomFieldValue(cf)?: 0)
}
return scores.sum {it}

Leonard Chew

I hear you! - One of the most annoying things in scripting with Scriptrunner and groovy is casting the numbers!

Try this workaround:

def n = Integer.parseInt((issue.getCustomFieldValue(cf) ?: 0).toString().replaceAll(~/[.].*/, ""))
def b = Integer.parseInt((issue.getCustomFieldValue(cff) ?: 0).toString().replaceAll(~/[.].*/, ""))

It gets the numeric value of the field, transforms it into a String, cuts of the decimal (.0) with a regular expression and then finally casts the string to an integer.

I'm sure there is a better solution, but at the time I needed to cast it, it was the solution that simply worked and so I just let it be.

Zita Bagi

Thank you, with this I managed to solve the parse issue.

There was still another problem, the way I expressed the sum amount was also incorrect, it just didn't take null into consideration. From another source I was given a solution for that:

Integer diference = (n ?: 0) + (b ?: 0);

Zita Bagi

@Peter Garncarek

@Leonard Chew

So here is the version which now works for me. Replace id1 and id2 with your actual custom field IDs.

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.search.SearchProvider
import com.atlassian.jira.web.bean.PagerFilter
import com.atlassian.jira.issue.IssueManager;
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.issue.link.IssueLinkManager
import com.atlassian.jira.user.ApplicationUser

def issueManager = ComponentAccessor.getIssueManager()
def linkManager = ComponentAccessor.getIssueLinkManager()
def cfm = ComponentAccessor.getCustomFieldManager()

Issue issueKey = issue
def id=issueKey.getId()

def customFieldManager = ComponentAccessor.getCustomFieldManager();

def cf = customFieldManager.getCustomFieldObject(id1)
def cff = customFieldManager.getCustomFieldObject(id2)

def n = Integer.parseInt((issue.getCustomFieldValue(cf) ?: 0).toString().replaceAll(~/[.].*/, ""))
def b = Integer.parseInt((issue.getCustomFieldValue(cff) ?: 0).toString().replaceAll(~/[.].*/, ""))

Integer sum = (n ?: 0) + (b ?: 0);

Leonard Chew

The null handling is already done (if null then it gets the value '0')

But I have just seen that my answer is crap. Stick to what @Peter Garncarek has suggested, because it is simpler and works :-)

def n = (Integer)(issue.getCustomFieldValue(cf) ?: 0)
def b = (Integer)(issue.getCustomFieldValue(cff) ?: 0)

if cf or cff are empty, their values will be 0, so there is no need to check any further.

Mohan Sundar_1ffuw2

After going through many other community posts for adding two custom fields and storing into 3rd field, your script worked like a charm!! I could not get the result in any other script as I was getting error incorrect method used though I have written all required imports.

Thankyou!

Mohan Sundar_1ffuw2

Could you help me with the error "cannot assign value of type java.math.BigDecimal to variable of type java.lang.integer"

I'm trying to find the average after adding two custom fields and as the return value is in Decimal I'm getting this error.

Please advise how to rectify this in your code.

kdickason

I have the same need as the original poster -- I have number fields I simply want to sum in a "Total" field. I have script runner. Can someone post for me the entire script that I could use to make this work? I'm a weak scripter and need the entire script, not just excerpts. Thanks you so much to anyone who can help.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

scriptrunner

custom-field

script-listener

adaptavist

jira-server

jira-core

groovy

script

jira-core-server

scripted-field