I am getting what appear to be inconsistent results with a JQL Query. In my database, I have 4153 tickets. I noticed some pecularities when running queries with "Request Type" and whittled it down to the following scenarios:
"(("Request Type" is empty) or ("Request Type" is not empty))" yields 4001 tickets (4153 were expected)
"not (("Request Type" is empty) or ("Request Type" is not empty))" yields 0 tickets (0 were expected)
Any ideas?
I am using JIRA v6.3-OD-08-005-WN
What type of custom field is "Request Type"?
Also, could you check the field context and the field configurations - I suspect you might find 152 issues are in projects that the field does not exist for.
Ran into it on Friday myself. I know it sort of makes sense when you think it through, but it's not obvious or intuitive! And I keep forgetting it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That was some amazing psychic debugging you just performed - you were exactly right.
When I restrict the query to a specific project, things work as expected.
Thanks for the quick reply!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.