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

How to update the custom field based on the value of another field

Bhawna Sharma

Hi,

I have two custom fields, say X and Y in the issuetype -bug.

I want the following to happen, after the bug is created -

1. Say X has the value "ABCD-1234". I want to truncate the value of X by removing the text after -, so that I get "ABCD" only

2. Now I want to update/replace the value of the another custom field i.e. Y as "ABCD" ( the value extracted above)

The field Y is a Select List (single choice)

Please help me how do I achieve this?

Any help is appreciated

Thanks in advance

Bhawna

Accepted answers

All comments

Leo_e8op2r

Hi @Bhawna Sharma,

Below script may give you some idea, I haven't tried in my instance. it may need some minor changes

Note: I've written this one for Script Listener, if you are going to run through post-function it needs minor change in field update query

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.CustomFieldManager
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.issue.customfields.manager.OptionsManager
import com.atlassian.jira.issue.customfields.option.Options
import com.atlassian.jira.issue.util.DefaultIssueChangeHolder
import com.atlassian.jira.issue.ModifiedValue

def myIssue = event.issue
def optionsManager = ComponentAccessor.getOptionsManager()
CustomFieldManager customFieldManager = ComponentAccessor.getCustomFieldManager()

def cfSource = myIssue.getCustomFieldValue(customFieldManager.getCustomFieldObjectByName("Source/Text Field")) as String
if(cfSource){
   def sourceValue = cfSource.split('-') as List
   def convert = "ABCD-"+sourceValue[1]
   def cfSelect = customFieldManager.getCustomFieldObjectByName("Select List Field Name")
   def fieldConfig = cfSelect.getRelevantConfig(myIssue)
   def optionsICUR = optionsManager.getOptions(fieldConfig)
   def optionToSet = optionsICUR.find{it.value == convert}

   def changeHolder = new DefaultIssueChangeHolder();
   cfSelect.updateValue(null,myIssue, new ModifiedValue(myIssue.getCustomFieldValue(cfSelect),optionToSet),changeHolder)
}

BR,

Leo

Bhawna Sharma

Thanks a lot Leo

I will try and let you know

Bhawna Sharma

Hi @Leo

I tried and tested exactly the same script.

However, in below- optionToSet is set to NULL

def optionToSet = optionsICUR.find{it.value == convert}

I am unable to figure out the reason. The value of convert is correct

Also, if you can pls help me explain the above script statement

Thanks

Bhawna

Leo_e8op2r

You said, the 2nd field Y is a select list which you need to update with new value right?

if so, that select list field should have this value as a option already e.g. ABCD-1234

This line will find the option from those list, if that value is not available as a option in select list field, will assign NULL to variable

I'm not sure what is your requirement, but to update values like this I would suggest single line text field rather than select list field, because the values may keep on changing and you can't add all of them as options to target field every time

If you are going to use Text field below script should work

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.CustomFieldManager
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.issue.customfields.manager.OptionsManager
import com.atlassian.jira.issue.customfields.option.Options
import com.atlassian.jira.issue.util.DefaultIssueChangeHolder
import com.atlassian.jira.issue.ModifiedValue

def myIssue = event.issue
def optionsManager = ComponentAccessor.getOptionsManager()
CustomFieldManager customFieldManager = ComponentAccessor.getCustomFieldManager()

def cfSource = myIssue.getCustomFieldValue(customFieldManager.getCustomFieldObjectByName("Source/Text Field")) as String
if(cfSource){
def sourceValue = cfSource.split('-') as List
def convert = "ABCD-"+sourceValue[1]
def cfTarget = customFieldManager.getCustomFieldObjectByName("Target Field Name")

def changeHolder = new DefaultIssueChangeHolder();
   cfTarget.updateValue(null,myIssue, new ModifiedValue(myIssue.getCustomFieldValue(cfTarget),convert),changeHolder)
}

BR,

Leo

Welcome!

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

Quick Links

Find more posts tagged with

scriptrunner

custom-field

jira-software

script-listener

behaviours