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; } } }

Make a scripted field multiply together the values of 3 custom fields

Daniel_Howard_77gtpc

I have 3 custom fields with the values of say 3, 7 & 8 - I want to stop the need for our 4th field to be manually updated by multiplying together these 3 values.

How can I create a scripted field that does the following

CustomFieldA * CustomFieldB * CustomFieldC = CustomFieldD (the scripted field)

Accepted answers

All comments

Leonard Chew

I gather you are using scriptrunner?

If so, this should do the job:

Create the Scripted Field "CustomFieldD" with this script:

import com.atlassian.jira.component.ComponentAccessor

def customFieldManager = ComponentAccessor.getCustomFieldManager()
def CustomFieldA = customFieldManager.getCustomFieldObjectsByName("CustomFieldA")[0]
def CustomFieldB = customFieldManager.getCustomFieldObjectsByName("CustomFieldB")[0]
def CustomFieldC = customFieldManager.getCustomFieldObjectsByName("CustomFieldC")[0]

def CustomFieldAValue = (issue.getCustomFieldValue(CustomFieldA) ?: 0) as float 
def CustomFieldBValue = (issue.getCustomFieldValue(CustomFieldB) ?: 0) as float 
def CustomFieldCValue = (issue.getCustomFieldValue(CustomFieldC) ?: 0) as float

return (CustomFieldAValue * CustomFieldBValue * CustomFieldCValue)

Daniel_Howard_77gtpc

Thanks for the update, so if I insert the fields like so - each of the fields are named below - they will have a value of 1 to 10.. tried this but the number field is not calculating?

import com.atlassian.jira.component.ComponentAccessor

def customFieldManager = ComponentAccessor.getCustomFieldManager()
def CustomFieldA = customFieldManager.getCustomFieldObjectsByName("FMEA Severity")[0]
def CustomFieldB = customFieldManager.getCustomFieldObjectsByName("Detectability")[0]
def CustomFieldC = customFieldManager.getCustomFieldObjectsByName("Occurrence")[0]

def CustomFieldAValue = (issue.getCustomFieldValue(CustomFieldA) ?: 0) as float
def CustomFieldBValue = (issue.getCustomFieldValue(CustomFieldB) ?: 0) as float
def CustomFieldCValue = (issue.getCustomFieldValue(CustomFieldC) ?: 0) as float

return (CustomFieldAValue * CustomFieldBValue * CustomFieldCValue)

Leonard Chew

What error do you get?

Daniel_Howard_77gtpc

Last logs error is this

Time (on server): Wed Feb 12 2020 16:26:16 GMT+0000 (Greenwich Mean Time)

The following log information was produced by this execution. Use statements like:log.info("...") to record logging information.

2020-02-12 16:26:16,379 ERROR [customfield.GroovyCustomField]: *************************************************************************************
Script field failed on issue: FMEA-277, field: RPN
org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast object '10' with class 'com.atlassian.jira.issue.customfields.option.LazyLoadedOption' to class 'float'
 at Script24.run(Script24.groovy:8)

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-server