Number of options selected in multi-choice field via JQL

Question

JQL:

For example I have a multi-choice field called Team nad I want via JQL to see all the Issue that are marked to impact more than one team. Writing an explicit querry (Teams = Team1 and Teams = Team2) is not an option as if I have 4 teams the possible combinations are 11.

Script:
How can I get the number of options selected for a multi-select custom field via Script.

Nic Brough -Adaptavist- · Answer

The code is a couple of years old, but should still work.  I'd break it down using a test issue - in the script-runner scripted field definition, there's a "preview" option, so you should use that to build up the query and see where it goes wrong.

i.e. try these (with the output type set to string)

return getCustomFieldValue (10090)

return getCustomFieldValue (10090).size()

Then add back the ? stuff - that's there to prevent errors when the field is empty or not valid for the issue.

Hans-Hermann Hunfeld · Answer

Got the same request, have to count the choosen options of a multi-select field. Created a scripted field and added your code, but seems to be not working?!

Any ideas?

Henning Tietgens · Answer

You can create a scripted field

return ((getCustomFieldValue(10090)?.size())?:0) as Double

to get the number of selected values for customfield 10090. Use Number template and searcher. After creating the field you have to reindex all issues.

Than you can use this field to find all issues with scripted_field > 2.