Search for issues with more than 1 value in a multi select field?

Question

I saw this question posted earlier but the suggested answer doesn't actually answer the question. That answer seemed to explain how to find a specific value.

I am, however, wanting to write a script to show issues that have more than one value selected in a multi-select field.

Use case: we have a Program Increment field on epics. This field is multi-select so we can report on epics that take more than one PI to complete. I want to run a script to show me epics where more than one option is selected in the Program Increment multi-select field.

CJ Edwards · Answer

Hi Cindi If you are going to groovy it, as Martin suggested, start with a JQL query to narrow results and then you can cycle through a find the ones that have more than one entry and "do" something you would like. This would need tweaking to your tastes jqlQueryParser = ComponentAccessor.getComponent(JqlQueryParser)
def searchService = ComponentAccessor.getComponent(SearchService)
def query = jqlQueryParser.parseQuery("project = myproject AND issuetype = Epic and 'Program Increment' is not EMPTY")
def search = searchService.search(user, query, PagerFilter.getUnlimitedFilter())
def issues = search.getResults()

issues.each{ issue ->

if (issue.getCustomFieldValue(sourceField).size()>1) {
do something! (spit out a list etc...)
}
}def customFieldManager = ComponentAccessor.getCustomFieldManager()
def sourceField = customFieldManager.getCustomFieldObject('customfield_10000') /need your actual # for Program Increment
def Hope this helps as well.

Cindi Lee · Answer

Thank-you. I will try that!

Martin Bayer _MoroSystems_ s_r_o__ · Answer

Hi @Cindi Lee , welcome on the community. I'm not aware of possibility to achieve this using JQL by default.

If you just want to run a groovy script, I think the most effective approach is to

* search for issues in required project with issue type Epic and Program Increment has at least one value, something like* project = myproject AND issuetype = Epic and 'Program Increment' is not EMPTY

* then load value of Program Increment custom field
* then filter issues which has more than 1 value in Program Increment custom field