JQL - Show all issues and show only recently closed issues

[Markus Ambrose]

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:

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

[Aron Gombas _Midori_]

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.

[Markus Ambrose]

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.