The JQL search operator != skips null values

XMLWordPrintable

    • Type: Bug
    • Resolution: Answered
    • Priority: Low
    • None
    • Affects Version/s: None
    • Component/s: 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)

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

              Created:
              Updated:
              Resolved: