"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

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!