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 ???
