Get all possible values of an assets/insight based custom field

Question

Hi,

I have an assets / insight based custom field B that is filtered via IQL based on the value in assets/insight based custom field A.  So far so good.  This all works.  But sometimes there aren't any possible values in field B if field A has a certain value.  If that is the case I would like to hide customfield B.

I now want to check in a groovy script what all the possible values for field A are.

I think that when I run the script and field A is empty , the result of the possible options should be empty and if field A has a value, the result should be the result of the IQL query.

I have searched the community, but for now have not been able to come up with something.  I found this article to get possible values of multiselect custom field, but when I run that script with correct parameters of my issue and field id it doens't give me any results :
https://community.atlassian.com/t5/Jira-questions/scriptrunner-how-to-get-possible-values-of-multiselect-custom/qaq-p/1363489

Doe anyone have an idea ?

PD Sheehan · Accepted Answer

This is the domain of Scriptrunner Behavious. Do you have access to that app?

If not, I'm not aware of any other way to conditionally show/hide a field like you suggested.

If you have scriptrunner, then it's a simple matter of picking up changes in field A, then constructing an IQL query with the selected value (the IQL must match the IQL you use in the field B configuration) and if the IQL returns no results, then set field B to hidden.

Something like this:

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

@BaseScript FieldBehaviours fieldBehaviours

def fieldA = getFieldByName('Customer(s)')
def fieldB = getFieldByName('B')

def fieldAValue = fieldA.value

def iql = """objectType = "object type for field b" and "field A attribute" = $fieldAValue"""
def searchResults = Assets.search(iql)

def showFieldB = searchResults.size() > 0
fieldB.setHidden(!showFieldB)