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

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Low Low
    • None
    • None
    • 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

              Unassigned Unassigned
              365decdd0e31 John
              Votes:
              11 Vote for this issue
              Watchers:
              12 Start watching this issue

                Created:
                Updated:
                Resolved: