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 ???
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.