JQL condition query results not correct

[Ellen Laszlo]

The IssueLinkType between issues in our system is critical for determining HOW the issue was created.  I need to search certain issue TYPES and then look at the IssueLinkType.

project = CPIT AND issuetype in ("Change Control", FireFighter, "Service request with approvals")     gets me 310 issues

project = CPIT AND issuetype in ("Change Control", FireFighter, "Service request with approvals") and issueLinkType is not EMPTY    gets me 290 issues

project = CPIT AND issuetype in ("Change Control", FireFighter, "Service request with approvals") and issueLinkType is EMPTY    gets me 20 issues

SO FAR -- SO GOOD  (310=290+20)

project = CPIT AND issuetype in ("Change Control", FireFighter, "Service request with approvals") and issueLinkType is not EMPTY and issueLinkType in ("from parent issue") gets me 257 issues

BUT  - I need those last 290-257=47 issues

project = CPIT AND issuetype in ("Change Control", FireFighter, "Service request with approvals") and issueLinkType is not EMPTY and issueLinkType NOT in ("from parent issue")

Any ideas ?   yes, its a complex query but nothing too extraordinary ???

[Ste Wright]

Hi @Ellen Laszlo 

This is a bit of a guess, but what happens if you take out issueLinkType is not EMPTY from the last two queries? Does that have any impact?

Ste