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

Multiply 2 numerical custom fields and display result in third custom field

Adrian_Avalos

Looking for a script that can be used to display the numerical outcome of two numerical custom fields in scriptrunner. Preferably behavuiour, but am open to adding in listener, custom scriptrunner field, or post function. Will need specifics as I'm very new to scriptrunner.

Custom Field A*Custom Field B=Custom Field C

Accepted answers

Adrian_Avalos

Thank you all. I found a solution via creating a custom field in scriptrunner. Below is what I used

import com.atlassian.jira.component.ComponentAccessor

def customFieldManager = ComponentAccessor.getCustomFieldManager()

def CustomFieldA = customFieldManager.getCustomFieldObjectsByName("CFA")[0]

def CustomFieldB = customFieldManager.getCustomFieldObjectsByName("CFB")[0]

def CustomFieldAValue = (issue.getCustomFieldValue(CustomFieldA) ?: 0) as float

def CustomFieldBValue = (issue.getCustomFieldValue(CustomFieldB) ?: 0) as float

return (CustomFieldAValue * CustomFieldBValue)

All comments

Fabio Racobaldo _Catworkx_

Hi @Adrian_Avalos and welcome,

you could use a calculated custom field provided by Script Runner and use the following code :

import com.atlassian.jira.component.ComponentAccessor

def customFieldManager = ComponentAccessor.getCustomFieldManager()

def aCF = customFieldManager.getCustomFieldObjectByName("Custom Field Name A")

def bCF = customFieldManager.getCustomFieldObjectByName("Custom Field Name B")

def aS = issue.getCustomFieldValue(aCF) as String

def bS = issue.getCustomFieldValue(bCF ) as String

def a = aS as Double

def b = bS as Double

if (a == null || b == null) return null

return (a * b) as Double

Please try it and let me know if it works.

Fabio

Nic Brough -Adaptavist-

I would use a version of Scriptrunner with HAPI enabled:

<span>lue</span><span>(</span><span>resultField</span><span>,</span><span> result</span><span>)</span>
<span>}</span><span>def</span><span> issueKey </span><span>=</span> <span>"YOUR_ISSUE_KEY"</span>
<span>def</span><span> firstNumberField </span><span>=</span> <span>"First Number Field"</span>
<span>def</span><span> secondNumberField </span><span>=</span> <span>"Second Number Field"</span>
<span>def</span><span> resultField </span><span>=</span> <span>"Result Field"</span>

<span>def</span><span> issue </span><span>=</span><span> Issues</span><span>.</span><span>getByKey</span><span>(</span><span>issueKey</span><span>)</span>

<span>def</span><span> firstNumber </span><span>=</span><span> issue</span><span>.</span><span>getCustomFieldValue</span><span>(</span><span>firstNumberField</span><span>)</span> <span>as</span><span> Double
</span><span>def</span><span> secondNumber </span><span>=</span><span> issue</span><span>.</span><span>getCustomFieldValue</span><span>(</span><span>secondNumberField</span><span>)</span> <span>as</span><span> Double
</span><span>def</span><span> result </span><span>=</span><span> firstNumber </span><span>*</span><span> secondNumber
</span>
<span>issue</span><span>.</span><span>update </span><span>{</span>
    <span>setCustomFieldVa</span>

This would work as a console script, but you would remove "issueKey" for a post-function or listener, and if you did it as a scripted field, it gets even shorter, as you drop the "issue update" bit, and instead of "Def result = ", use "return "

I'd avoid a Behaviour for this, because that means having fields on screen that people could then amend later, and won't work if people make updates or edits with REST calls or apps that don't use the API.

Adrian_Avalos

Thank you all. I found a solution via creating a custom field in scriptrunner. Below is what I used

import com.atlassian.jira.component.ComponentAccessor

def customFieldManager = ComponentAccessor.getCustomFieldManager()

def CustomFieldA = customFieldManager.getCustomFieldObjectsByName("CFA")[0]

def CustomFieldB = customFieldManager.getCustomFieldObjectsByName("CFB")[0]

def CustomFieldAValue = (issue.getCustomFieldValue(CustomFieldA) ?: 0) as float

def CustomFieldBValue = (issue.getCustomFieldValue(CustomFieldB) ?: 0) as float

return (CustomFieldAValue * CustomFieldBValue)

Welcome!

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

Quick Links

Find more posts tagged with

server

scriptrunner

jira-software

jira-software-server

script