Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-22130

JQL: Invalid or incomplete result sets when querying for "watcher" vs. "not watcher"

    XMLWordPrintable

Details

    Description

      I have 3 queries:

      1) reporter = currentUser() and resolution = Unresolved --This yields 98 issues.

      2) reporter = currentUser() and resolution = Unresolved and watcher = currentUser() --This yields 34 issues.

      1) reporter = currentUser() and resolution = Unresolved and watcher != currentUser() --This yields 3 issues.

      61 tickets are unaccounted for (clearly, 34 + 3 does not equal 98.) Many issues are being missed, and it's hard to tell where. I think it may be issues where I and other people are watching. Plural watchers seems to throw off the match.

      I used that query because it was a relatively small result set. The same can be done with only this field (more expensive):

      1) {{ [empty query] }} --This yields 41,113 issues.

      2) watcher = currentUser() --This yields 207 issues.

      1) watcher != currentUser() --This yields 4,035 issues.

      37,078 tickets are unaccounted for.

      The problem can't be one of security level, because then the baseline queries (with the total numbers) should have also been decreased by the number of tickets I cannot view.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              c6973072ac32 John M. Black
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: