Are you in the loop? Keep up with the latest by making sure you're subscribed to Community Announcements. Just click Watch and select Articles.

Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


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

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


2 answers

1 accepted

1 vote
Answer accepted
Joseph Chung Yin
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Nov 15, 2023

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

Hope this helps and give you an idea.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.

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

0 votes
Becky Brooks - Visor for Jira
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Nov 16, 2023

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:

I hope that helps! 

- Becky @ Visor

Suggest an answer

Log in or Sign up to answer
Site Admin
AUG Leaders

Atlassian Community Events