When searching for Issues, negative filtering does not return empty values

XMLWordPrintable

    • Type: Bug
    • Resolution: Duplicate
    • Priority: Low
    • None
    • Affects Version/s: None
    • Component/s: JQL

      NOTE: This bug report is for JIRA Server. Using JIRA Cloud? See the corresponding bug report.

      In the Issue Navigator, if you filter on "not equal to <field>" then the search query returns only tickets that have an field value that is not equal to the specified in the filter, but does not return issues where that field is empty.

      Steps to reproduce:
      1. go to the Issue Navigator and enter a search query, e.g. Project = <project_name>

      2. change the query to exclude a value in on of the fields, here Project = <project_name> and Sprint != <sprint_ID>

      Result: Issues not assigned to any Sprint aren't included in the results.

      Workaround

      Include a OR IS EMPTY clause in the query, e.g. (Sprint != <sprint_ID> OR Sprint IS EMPTY)

        1. search1.png
          search1.png
          163 kB
        2. search2.png
          search2.png
          64 kB

            Assignee:
            Unassigned
            Reporter:
            John
            Votes:
            11 Vote for this issue
            Watchers:
            12 Start watching this issue

              Created:
              Updated:
              Resolved: