How to I get the values of cascading field using ScriptRunner

Zaldy Parian

Hi all,

We're using JSM Cloud and I'm exploring ScriptRunner to assign value to a custom field based on the values (parent and child) of a cascading field. 

My custom cascading field is Issue category / sub-category.

How do I get the values of parent and child cascading field in ScriptRunner Listener when it is changed?

I'm really desperate to get the script working as soon as possible.

 

Regards,

Bobby Bailey

Hi @Zaldy Parian , 

There are a couple of steps that you need to go through to do this. First, as you have mentioned you want to set up a listener that executes when the issue is updated. 

Then, we need to check to see if the cascading field was updated. When you create a listener, you will see in the script context that we have the changelog variable defined. This gives us access to what was changed in this update, you can see the structure of this data here: https://developer.atlassian.com/server/jira/platform/webhooks/#executing-a-webhook

So, using the follow if statement, we filter out any change that doesn't involve the cascading field:

// Change 'Custom Cascading Fields' to your field name
def item = changelog.items.find{ item -> item.field == "Custom Cascading Fields"}

if(item){
  // code here will execute if the cascading fields have been updated
}  

Then, we can access the issue data to get the field values: 

// Change 'customfield_10123' to your custom field name
 def parentValue = issue.fields.customfield_10123.value
def childValue = issue.fields.customfield_10123.child.value

So, total code would look like this: 

def item = changelog.items.find{ item -> item.field == "Custom Cascading Fields"}

if(item){
def parentValue = issue.fields.customfield_10123.value
def childValue = issue.fields.customfield_10123.child.value

// Add any logic you need from the field values here
} else {
logger.error('Wrong update!')
}

Does this help? 

Kind regards, 

Bobby