"Resolution" field "NOT IN" operator is showing incorrect data in JQL

[Kalpathi Rajkumar Harishma]

Hi,

When I'm trying to give a JQL with "Resolution" as below, the tickets with "Resolution" as "Unresolved" are not capturing in the result data, could you please help to find the issue and provide the correct JQL to proceed.

JQL E.g.,

resolution NOT IN ("Duplicate", "Not a Defect", "Canceled / Rejected")

[Dexter de Vera · Accepted solution]

Hi @Kalpathi Rajkumar Harishma 

Your JQL expect a value from resolution, you may add " OR resolution = Unresolved" to include also the empty / Unresolved resolution.

resolution NOT IN ("Duplicate", "Not a Defect", "Canceled / Rejected") OR resolution = Unresolved

Hope it helps!

[Kalpathi Rajkumar Harishma]

@Dexter de Vera 

It worked Thanks!