jqlTooComplex response when using != operator with a Select List (Single choice)

XMLWordPrintable

    • 1
    • Severity 3 - Minor

      Issue Summary

      When using a custom field of type 'Select List (single choice)', it is not possible to use the != operator. Doing so results in a jqlTooComplex error.

      Steps to Reproduce

      1. Add a custom field of type 'Select List (single choice)' E.g Department
      2. Add a single value option (see screenshot: Select List with one option) E.g DSI
      3. Associate the new custom field with some screens.
      4. In a project create an issue and select the DSI option from the Select List
      5. In a project create a second issue and do not select any option from the Select List
      6. In the issue navigator enter the following JQL
        Department != DSI
        

      Expected Results

      The JQL should return any issues where the value of the field is not equal to DSI

      Actual Results

      No results.

      Checking the dev tools it can be seen that:

      • QueryComponent!Jql.jspa returns an HTTP 400 response
      • A preview of the response shows the jqlTooComplex error

      Workaround

      Formulate the JQL query with the inverse E.g

      FROM:

      Department != DSI
      

      TO:

      Department = ART OR Department IS EMPTY
      

        1. 400 response code - jqlTooComplex-1.png
          82 kB
          Daniel Davies
        2. Select List not equals operator - jqlTooComplex.png
          55 kB
          Daniel Davies
        3. Select List with one option.png
          73 kB
          Daniel Davies

              Assignee:
              Unassigned
              Reporter:
              Daniel Davies (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: