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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Low
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: JQL
    • Labels:

      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

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: