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

ScriptRunner Jira Cloud - Convert String to Integrer

Jeanne Howe_56oel8

I am attempting to create a scripted field that will calculate Risk based on Impact and Likelihood.

Both the Impact and Likelihood fields are a single select dropdown field. To do the calculation, I need to convert the String to an Integer. In Jira Datacenter, I know I can create an If/else statement that looks something like this:

def likelihood = issue.getCustomFieldValue(customFieldManager.getCustomFieldObjectByName("Risk Likelihood"))

if ( "Rare".equals (likelihood.getValue()) ) {

likelihood = 1

} else if ( "Unlikely".equals (likelihood.getValue()) ) {

likelihood = 2

} else if ( "Moderate".equals (likelihood.getValue()) ) {

likelihood = 3

} else if ( "Likely".equals (likelihood.getValue()) ) {

likelihood = 4

} else if ( "Almost Certain".equals (likelihood.getValue()) ) {

likelihood = 5

} else {

return null

}

On Jira Cloud, I can not use .equals

Does anyone know the Cloud equivalent?

Accepted answers

All comments

Jack Nolddor [Sweet Bananas]

Hi Jeanne Howe and welcome,

Do you mind to share with us how your actual code looks like the whole stacktrace of the error to see if anyone here can help you with your problem? You can use https://pastebin.com/ site to share those files with us.

Depending of the language used on your Cloud script you will be able to use .equals() method or not, Groovy / Java based language have this method available for each existing variable on the code since this method is provided by Object.class, the one every variable on those languages extend from.

Best Regards

Kristian Walker _Adaptavist_

Hi Jeanne,

I can confirm if the value returned in your script is a string you can use the parseInt() method that groovy provides to return it as an integer as documented in the groovy docs located here.

I hope this helps.

Regards,

Kristian

Jeanne Howe_56oel8

@Kristian Walker _Adaptavist_ @Jack Nolddor [Sweet Bananas]

Thank you both for the responses. I have "cheated" a little bit here and add a numeric value to each of my fields, so I can parse the field instead of trying to convert the string to integer.

The scripted field is working, but I am trying to change the calculation that is being performed. The current calculation adds the two field values:

def output = impact[0..0]+likelihood[0..0] as Integer

I would like to multiply the two field values:

def output = impact[0..0]*likelihood[0..0] as Integer

To do this I believe I need to declare a method - but have no idea what that method is.

This is a snippet of the error I see:

org.codehaus.groovy.runtime.InvokerInvocationException: groovy.lang.MissingMethodException: No signature of method: java.lang.String.multiply() is applicable for argument types: (String) values: [1] Possible solutions: multiply(java.lang.Number) at TestScriptedFieldExecution2_groovyProxy.run(Unknown Source) Caused by: groovy.lang.MissingMethodException: No signature of method: java.lang.String.multiply() is applicable for argument types: (String) values: [1] Possible solutions: multiply(java.lang.Number)

Here is the code that I have working so far:

def input1CfId = 'customfield_12025'//Risk Likelihood string
def input2CfId = 'customfield_12024' //Risk Impact string
def outputCfId1 = 'customfield_12026' //Rick Score Integer

def impact = issue.fields[input1CfId]['value'] as String
def likelihood = issue.fields[input2CfId]['value'] as String

def output = impact[0..0]+likelihood[0..0] as Integer

put("/rest/api/2/issue/${issue.key}")
.header("Content-Type", "application/json")
.body([
fields:[
(outputCfId1): output
]
])
.asString()

Any thoughts on how to modify this to multiply the two values instead of adding?

(would also appreciate any thoughts you had on the script formatting. I am very new to this)

Jeanne

Jeanne Howe_56oel8

I believe I have the Scripted field working. Would appreciate any feed back on the script formatting, I am still very new to this. Here is my scripted field:

def input1CfId = 'customfield_12025'//Risk Likelihood string
def input2CfId = 'customfield_12024' //Risk Impact string
def outputCfId1 = 'customfield_12026' //Rick Score Integer

def impact = issue.fields[input1CfId]['value'] as String
def likelihood = issue.fields[input2CfId]['value'] as String

def impactint = impact[0] as Integer
def likelihoodint = likelihood[0] as Integer

def output = impactint * likelihoodint as Integer

return output

put("/rest/api/2/issue/${issue.key}")
.header("Content-Type", "application/json")
.body([
fields:[
(outputCfId1): output
]
])
.asInteger

Kristian Walker _Adaptavist_

Hi Jeane,

The error message indicates the values are still stored as strings and you cannot perform mathematical operations on Strings.

This means you will need to parse the strings to convert them to integer values which are stored as integer values and then you can multiply these integer values in your script.

Regards,

Kristian

Jeanne Howe_56oel8

Thanks Kristian,

I have modified my comment above. I think I have it working.

Welcome!

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

Quick Links

Find more posts tagged with

scriptrunner

cloud

jira-software

jira-software-cloud

jira-cloud

scripted-field