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: Limit values in a single select field based on value selected in second single select

Michael_qy22gs

Hi everyone,

New groovy user here, and I've been trying to figure out a scriptrunner behavior for how to limit values within a single select custom field based on the option selected within an above single select custom field.

A quick google search brings you to several "answers" for this question; but the current behavior editor returns errors / issues with every "answer" I've found - hence I'm asking here.

End Goal Example:

Single Select Field #1: "States" (Values = Michigan, Ohio, New York)

Single Select Field #2: "Cities" (Values = Detroit, Saginaw, Dayton, Columbus, New York City, Buffalo)

I want to limit the available values in "Cities" so that only the "Cities" that are within the corresponding "States" are shown:

Michigan = Detroit, Saginaw

Ohio = Dayton, Columbus

New York = New York City, Buffalo

Can someone please help us with this issue?

Thanks,

Mike

Accepted answers

Ram Kumar Aravindakshan _Adaptavist_

Hi @Michael

This appears to be a very common Behaviour question.

You can find a similar question and solution in this Community Post.

Thank you and Kind regards,

Ram

All comments

Ram Kumar Aravindakshan _Adaptavist_

Hi @Michael

This appears to be a very common Behaviour question.

You can find a similar question and solution in this Community Post.

Thank you and Kind regards,

Ram

Michael_qy22gs

Thanks Ram,

The first time I entered the coding for this within my editor it didn't work when I modified to fit my environment; but for some reason it worked now. Sorry for wasting your time!

Michael_qy22gs

Hi again Ram,

I spoke too soon in my reply; the editor seemed to be OK with the code input, but when I go to test out the code it just doesn't filter the field to the options I input within "list 2". (All options are still available)

Should I reply within the original thread with my query? Or would you prefer I reply here?

Ram Kumar Aravindakshan _Adaptavist_

Hi @Michael

Could you please share a screenshot of your Behaviour configuration?

I will review it and provide some feedback.

Please continue in thread.

Thank you and Kind regards,

Ram

Michael_qy22gs

Hi again Ram,

I believe (and I could be wrong since I've very new here) my issue was a combination of using the same field within another groovy script on the same form as well as changing the scripting for the "null" value within "List 2".

I now have it working, and I'll post my code below for anyone who happens to find their way to this page and wants to use it.

Code Explanation:
Our team uses a very similar code to what was previously provided by you within the linked thread, but with one exception - we wanted to include all values within the second field if the "Null" option was left. This is because we either use a single select list for values, OR a text field for "potential" new values that we might add to "List 1" at a later date.

With that said:

1) I've customized the script so the the "List 1" is defined by the field's Jira "customfield_ID" instead of the "(fieldChanged)" action.

2) I've also incorporated the "null" value within the "else if" statements.

Michael_qy22gs

Here is the completed code which works correctly for our needs:

import com.atlassian.jira.component.ComponentAccessor

import com.onresolve.jira.groovy.user.FieldBehaviours

import groovy.transform.BaseScript

@BaseScript FieldBehaviours fieldBehaviours

//the "ID" of the field goes where "12345" is if the field you are referencing is a custom field

def list1 = getFieldById("customfield_12345")


def list1Value = list1.value.toString()

def list2 = getFieldByName("List 2")

def optionManager = ComponentAccessor.optionsManager

def customFieldManager = ComponentAccessor.customFieldManager

def list2CustomField = customFieldManager.getCustomFieldObject(list2.fieldId)

def list2Config = list2CustomField.getRelevantConfig(issueContext)

def list2Options = optionManager.getOptions(list2Config)

def listBNewOptions

if(list1Value == "null") {

    listBNewOptions = ["option 1","option 2","option 3","option 4","option 5"]

} else if(list1Value == "Zone 1") {

    listBNewOptions = ["option 1"]

} else if(list1Value == "Zone 2") {

    listBNewOptions = ["option 2","option 3"]

} else if(list1Value == "Zone 3") {

    listBNewOptions = ["option 1","option 5"]

}

list2.setFieldOptions(listBNewOptions)

Michael_qy22gs

Welcome!

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

Quick Links

Find more posts tagged with

server

scriptrunner

jira

jira-server

behaviours