You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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?
Give this a try -
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
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!
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