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

JIRA Update Issue Custom Field from cascading select

Robert G. Nadon

Hi all,

I hope someone can help. Here is what we are trying to accomplish. I was asked to make the field Components selectable based upon a custom field value called product.

Here was my proposal:

Add a new cascading select field called product-component with product as the first choice and then the various component choices
In a post function copy the second of the cascading list component to components
in another post function copy the top value of the cascading list to product

Everything works except 3. I have tried a basic copy, then I tried Update Issue Custom Field with the following values:

Try2: ${issue.customfield_13502.toString()}

Try3: ${issue.cfValues['product-component']*.value} or ${issue.cfValues['customfield_13502']*.value}

Try4: ${issue.getCustomFieldValue(getCustomFieldObjectByName("customfield_13502"))}

Try5: ${issue.getCustomFieldValue("customfield_13502")}

try 6: ${issue.getCustomFieldValue(customfield_13502)} or $issue.getCustomFieldValue(product-component)

try 7: ${issue.product-component} or ${issue.customfield_13502:1}

None of which worked

Does anyone know how I could get the value from the top part of a cascading select list called product-component (customfield_13502) into another select list custom field? I will ensure that the first part of product-component has exact values of the customer single select list called product.

Thanks!!!

Robert

Accepted answers

David _old account_

You can instead use JMWE's "Set Field Value to Constant or Groovy Expression" post-function with a simple Groovy script:

import com.atlassian.jira.issue.fields.CustomField;
import com.atlassian.jira.component.ComponentAccessor;
CustomField customField = ComponentAccessor.getCustomFieldManager().getCustomFieldObjectByName("&lt;name of your cascading field&gt;");
def value = issueObject.getCustomFieldValue(customField);
return value?.get(null)?.getValue();

I didn't test this code so there might be an error in it but you get the gist.

Note that the script uses the "issueObject" variable, which is an instance of JIRA's Issue interface.

All comments

Vijay Khacharia

Each option in JIRA customfield has an optionID. You have two fields product-component and product, both are select lists. So you to get the correct option ID for product field and set the value to that. Here you are trying to set the same value which wont work, as it is option for product-component field.

For getting the option for the field you can use

customField.getRelevantConfig(issue)).getOptionForValue("option", null)

Robert G. Nadon

Thanks Vijay! I appreciate the help... What post function should I use with the above?

Set Field Value to constant or Groovy expression
Update Issue Custom Field
Copy Value From Field to Field

Actually product-component is a cascading select and product is a regular select. The above "option" is the product-component ID. IE product-component is also customfield_13502, going into each option also give me an ID, but that is what I am looking for. so here is what product-component returns: linux-gui, linux-installation, windows-interface, windows-installation, windows-bsod, etc. What I am looking put in the product field is linux or windows. As product is a single select list with Linux and Windows as the options.

So is the "option" above the option ID from the customfield (13502) or the option ID (the ID of linux-interface for example)?

Excuse my novelty, but I am trying to write a post function, not a plugin, though one day I hope to get there.

Vijay Khacharia

I would use a script post function and put a groovy script to do this.

Get the value for "Product-component" field.
Check if it is "Linux-interface" or "Linux-Installation"
- Look for the optionID for value "Linux" for the field "Product"
```
cfProduct.getRelevantConfig(issue)).getOptionForValue("Linux", null)
```
If it is "Windows-Interface" or "Windows-installation", etc.
- Look for optionID for value "Windows" for the field "Product"
Set the value of Product field
Update the issue

Below answer will be helpful if you are new to groovy.

https://answers.atlassian.com/questions/189262

Robert G. Nadon

I believe I understand the confusion here. I am first just trying to return the value of Product-component to a text field for now, as I cannot even seem to get the value of the multiselect field. If I can get the value of Product-component, setting the field, I think, will be the easy part.

Robert G. Nadon

Looks like the only answer I can get to work is this https://innovalog.atlassian.net/browse/JMWE-178 which allows me to create a Calculated Text field which will display the parent, and see that instead of a post function copy. That answer is less than ideal as then the cascading select and the components can be out of sync if someone edits the component, but it is the best I can get working. Thanks @Vijay Khacharia for all your help, but I get errors with all the recommended groovy scripts. (possibly as I am still using the last free version of script runner)

David _old account_

You can instead use JMWE's "Set Field Value to Constant or Groovy Expression" post-function with a simple Groovy script:

import com.atlassian.jira.issue.fields.CustomField;
import com.atlassian.jira.component.ComponentAccessor;
CustomField customField = ComponentAccessor.getCustomFieldManager().getCustomFieldObjectByName("&lt;name of your cascading field&gt;");
def value = issueObject.getCustomFieldValue(customField);
return value?.get(null)?.getValue();

I didn't test this code so there might be an error in it but you get the gist.

Note that the script uses the "issueObject" variable, which is an instance of JIRA's Issue interface.

Robert G. Nadon

Wow that did it!!! THANK YOU!!! We are good the exact script above (with the obvious replacement of the name of the cascading field worked perfectly. Case closed

Sandra Meessen

Hi @David _old account_ , I want to use your code (I'm completely new to Groovy) for solving my problem:

I have cascading custom field and 2 single custom fields. I want to copy the parent part of the cascading to one custom field and the child part to the other custom field. I followed the steps of initiator Robert and succeeded in copying the child part to the other custom field.

For the parent I want to use your code, but I don't understand where to put the name of the cascading (parent) and where the name of the custom field copying to. Can you help me please? Thanks!

David Fischer

Hi Sandra,

which app are you using (JMWE or ScriptRuner)?

Welcome!

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

Quick Links

Find more posts tagged with

scriptrunner

jira

jira-core

jira-misc-workflow-extensions

jira-misc-custom-fields