jira query issue

[Samuel]

I have these 3 queries

project = Test AND issuetype = Defect AND "Custom Field" = "vaule A"  This one returns 10 items
project = Test AND issuetype = Defect AND "Custom Field" = "vaule A" AND resolution in (fixed)  This one returns 6 items
project = Test AND issuetype = Defect AND "Custom Field" = "vaule A" AND resolution not in (fixed)  I expect this one to return 4 items but only returns 1

What am I doing wrong ?

[Jobin Kuruvilla [Adaptavist] · Accepted solution]

You have most probably 3 issues which doesn't have any resolution on it.

project = Test AND issuetype = Defect AND "Custom Field" = "vaule A" AND resolution is EMPTY

should return 3 items.

project = Test AND issuetype = Defect AND "Custom Field" = "vaule A" AND (resolution not in (fixed) or resolution is EMPTY)

should return 4 items.