Trying to use 2 custom fields to determine a scripted field value using ScriptRunner Script Fields

Question

Hi,

I have 2 custom fields configured as Select List (single choice) which is completed on a screen during the workflow's 1st transition.  These 2 fields are used to determine the 3rd custom field which is configured as a Scripted Field.

Below is the script however when using the PREVIEW option, it always returns a NULL result even though the Preview Issue Key used has values that are in the def values section.  Configure Context and Screens has been completed.

I have also created a ticket using both scenarios in the def values section however the scripted field is not displaying on the screen configured.

Would greatly appreciate any advice on how to rectify this issue.

import com.onresolve.jira.groovy.user.FieldBehavioursimport groovy.transform.BaseScript
@BaseScript FieldBehaviours fieldBehaviours
int consequenceId = 17301int likelihoodId = 17300int targetFieldId = 17302
def consequence = getFieldById("customfield_" + consequenceId)def consequenceValue = consequence.getValue()def likelihood = getFieldById("customfield_" + likelihoodId)def likelihoodValue = likelihood.getValue()def targetField = getFieldById("customfield_" + targetFieldId)
def values = [[Consequence:"Severe", Likelihood:"Certain", TargetValue:"High"],[Consequence:"Minimum", Likelihood:"Rare", TargetValue:"Low"]]
def targetFieldValue = values.find { it.Consequence == consequenceValue && it.Likelihood == likelihoodValue}?.TargetValueif (targetFieldValue != null){targetField.setFormValue(targetFieldValue)}

Sachin Dhamale_o1c5zi · Accepted Answer

@Amanda Tippett

If you are using scripted field then you can update them in post function.

if you are using the behavior script then you can use normal text field to update.

Thanks,

Sachin

Amanda Tippett · Accepted Answer

This is the behavior script that now works with the targetField a custom text field and the consequence and likelihood fields list single choice fields.import com.onresolve.jira.groovy.user.FieldBehavioursimport groovy.transform.BaseScript
@BaseScript FieldBehaviours fieldBehaviours
int consequenceId = 17301int likelihoodId = 17300int targetFieldId = 17309
def consequence = getFieldById("customfield_" + consequenceId)def consequenceValue = consequence.getValue()def likelihood = getFieldById("customfield_" + likelihoodId)def likelihoodValue = likelihood.getValue()def targetField = getFieldById("customfield_" + targetFieldId)
def values = [[Consequence:"Severe", Likelihood:"Certain", TargetValue:"Reportable"],[Consequence:"Severe", Likelihood:"Likely", TargetValue:"Reportable"],[Consequence:"Severe", Likelihood:"Possible", TargetValue:"Reportable"],[Consequence:"Severe", Likelihood:"Unlikely", TargetValue:"Reportable"],[Consequence:"Severe", Likelihood:"Rare", TargetValue:"Reportable"],[Consequence:"Major", Likelihood:"Certain", TargetValue:"Reportable"],[Consequence:"Major", Likelihood:"Likely", TargetValue:"Reportable"],[Consequence:"Major", Likelihood:"Possible", TargetValue:"Reportable"],[Consequence:"Major", Likelihood:"Unlikely", TargetValue:"Reportable"],[Consequence:"Major", Likelihood:"Rare", TargetValue:"Reportable"],[Consequence:"Moderate", Likelihood:"Certain", TargetValue:"Investigate"],[Consequence:"Moderate", Likelihood:"Likely", TargetValue:"Investigate"],[Consequence:"Moderate", Likelihood:"Possible", TargetValue:"Investigate"],[Consequence:"Moderate", Likelihood:"Unlikely", TargetValue:"Investigate"],[Consequence:"Moderate", Likelihood:"Rare", TargetValue:"Review"],[Consequence:"Minor", Likelihood:"Certain", TargetValue:"Review"],[Consequence:"Minor", Likelihood:"Likely", TargetValue:"Review"],[Consequence:"Minor", Likelihood:"Possible", TargetValue:"Review"],[Consequence:"Minor", Likelihood:"Unlikely", TargetValue:"Track"],[Consequence:"Minor", Likelihood:"Rare", TargetValue:"Track"],[Consequence:"Minimum", Likelihood:"Certain", TargetValue:"Track"],[Consequence:"Minimum", Likelihood:"Likely", TargetValue:"Track"],[Consequence:"Minimum", Likelihood:"Possible", TargetValue:"Track"],[Consequence:"Minimum", Likelihood:"Unlikely", TargetValue:"Track"],[Consequence:"Minimum", Likelihood:"Rare", TargetValue:"Track"]]
def targetFieldValue = values.find
{ it.Consequence == consequenceValue && it.Likelihood == likelihoodValue}?.TargetValueif (targetFieldValue != null){ targetField.setFormValue(targetFieldValue) }