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 · Accepted solution]

@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.

[Gene Sullivant]

Thank you Joseph, this is exactly what I needed. I appreciate you taking the time to answer this cry for help and also to attach the Filters documentation. I had opened and reviewed that doc as I tried to work through the JQL. 

What was enlightening was your use of parenthesis even when it was a single item as I had not seen that before. I now see it in the Examples that I missed before under Custom Fields.

Thank you very very much!

Gene Sullivant

US Bank

[Becky Brooks - Visor for Jira]

Hi @Gene Sullivant ,

You can do that with JQL in Jira or using a tool like Visor.

You can import your Jira data to Visor (which supports filtering and dropdown and multi-select fields). Visor lets you create Custom Views based on criteria like what dropdown fields are selected. You can also color code them, which makes it easy to see them when the rest of your data. Lastly, you can make changes inline in Visor and push them back out to Jira.

This would be the less technical way to accomplish this:

https://marketplace.atlassian.com/apps/1226209/visor-flexible-spreadsheet-for-jira-roadmapping-bulk-edits?hosting=cloud&tab=overview

I hope that helps! 

- Becky @ Visor