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

The JQL search operator != skips null values

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Answered
    • Icon: Low Low
    • None
    • None
    • None

      When performing a search using the != operator, issues with a null value in the specified field is not returned.

      For example:
      Project is Test
      Issue1 has label 'bug'
      Issue2 has label 'task'
      Issue3 does not have a label set.

      Running the query:

      PROJECT = 'Test' AND LABEL != 'bug'

      This only returns Issue2 and not Issue3

      Workaround is to use the query:

      PROJECT = 'Test' AND (LABEL != 'bug' OR LABEL is empty)

              Unassigned Unassigned
              dchan David Chan
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: