I need a 2 Custom Filter on a Custom Field w/ Multi-select field.

Gene Sullivant

I need a Filter that allows me to retrieve issue with 2 of the 6 multi-select options but them must be together not separate.

Example, Field is Fruit and context is Apple, Banana, Kiwi and Orange. I need a filter that can retrieve issues with Kiwi AND Orange together, or Empty, or with other items. But can't be just Kiwi or just Orange. 

The 2nd Filter is to show all Issues that don't have Kiwi and/or Orange selected. So everything except those two included or Empty. 

I have been working on this for awhile but the Syntax doesn't seem to cooperate. What works with a Multi-select Custom field to exclude context items?

Thanks, Gene

 

Joseph Chung Yin

@Gene Sullivant -

Give this a try -

Query one:  

• project = <your project key> and Fruit[Checkboxes] in (Orange) and "Fruit[Checkboxes]" in (Kiwi)" -  This one will give you when the Fruit field is Orange and Kiwi exactly within a project.

Query two: 

• "(project = <your project key> and Fruit[Checkboxes] is empty) or (project = <your project key> and Fruit[Checkboxes] is not empty and filter not in "<the name of query in Query one the you saved>") - This one will give all the issues from a project where the Fruit field is NULL and issues from the a project where Fruit field is not NULL and not in the saved query filter as described in Query one.

Here is the JQL reference page on the usage of "Filter" JQL field - https://support.atlassian.com/jira-service-management-cloud/docs/jql-fields/#Filter

Hope this helps and give you an idea.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.