Custom field filtering by value from another custom field, multi select required

David Hightower_igfx1p

@Nic Brough -Adaptavist-

@Jamie Echlin _ScriptRunner - The Adaptavist Group_

I'm looking for javascript or another option (scriptrunner is installed), to allow filtering of custom field B based on custom field A values. I've tried Cascading selects and they don't work for me due to the multi select need on the second custom field.

Custom field B will filter based on the selection of A and allow a selection of multiple values.

A :

• 1
  • B values:
    • A
    • B
    • C
• 2
  • B values:
    • D
    • E
    • F
• 3
  • B values:
    • G
    • H
    • I

Can anyone suggest a method to pull this off, without installing another plugin than scriptrunner?

A and B are required

these are mocked up in html, not as custom fields yet. 

If A:1 is selected, the user can select any combination of the A,B,C values from B. 

If A:2 is selected, the user can select any combination of the D, E, F values from B.

etc..

Joanna Choules

Hi David,

The recommended approach via ScriptRunner would probably be to use Behaviours. You would want to set up a server-side script on the single-select field which restricts the multi-select field's options using setFieldOptions:

import com.atlassian.jira.component.ComponentAccessor

def singleSelect = getFieldById(fieldChanged)

def multiSelect = ComponentAccessor.customFieldManager.getCustomFieldObjectByName("CustomFieldB")
def msConfig = customField.getRelevantConfig(issueContext)
def msOptions = ComponentAccessor.optionsManager.getOptions(msConfig)

def filteredOptions = msOptions

switch (singleSelect.value) {
    case "1":
        filteredOptions = msOptions.findAll {it.value in ['A', 'B', 'C']}
        break

    case "2":
        filteredOptions = msOptions.findAll {it.value in ['D', 'E', 'F']}
        break
}

formField.setFieldOptions(filteredOptions)