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

Details

    • Bug
    • Resolution: Duplicate
    • Low
    • None
    • None
    • JQL

    Description

      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)

      Attachments

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

        Issue Links

          duplicates

          Suggestion - JRASERVER-23030 Not equals operator (!=) excludes results with empty values

          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. JRASERVER-29269 'Not in' in a JIRA search excludes empty results - it amounts to 'where <field> is not empty, and not in (range)'.

          • Low - Low priority issues
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. JRACLOUD-29179 When searching for Issues, negative filtering does not return empty values

          • Low - Low priority issues
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: