JQL - Show all issues and show only recently closed issues

Question

Hi All,

I have the field "System" that can contain more than one value. I would like to show only the issues that have only a specific system.

* e.g If the issue 001 have System "alba" and "beta" but I want to show all the issues that have only the system "alba" I expect that I'll not see the issue 001.

I know that I can use this workaround:

* system is "alfa" and is not "beta", "gamma" etc.

But I would like to know if there is a better way to do the filter.

Thank you in advance for your Help

Markus Ambrose · Answer

Well If I write

* System In/= "Alfa"

Jira doen't show me only the issues with that single "system" but also issues like these:

* Issue 1 - System: "Alfa": "Beta"
* Issue 2 - System: "Gamma", "Alfa"

If a field contains few values it's not a problem to use operator NOT IN or != but If a field have for exemple 70 different values it can't lead to error that will mess a filters/reports.

Aron Gombas _Midori_ · Answer

I think it depends on the type of the custom field.

But generally speaking the equals (=) and IN operators should be used for exact and for "partial" matches, repsectively.