Uploaded image for project: 'Jira Platform Cloud'
  1. Jira Platform Cloud
  2. JRACLOUD-71739

JQL order by on jira date custom field with duplicate values cause 500 error

XMLWordPrintable

      This a failing example caused by this issue

      https://jira.atlassian.com/browse/JSDCLOUD-5674

      We can reproduce this bug by
      1. Create a request in JSD
      2. Resolve the request
      3. Check your email
      4. answer the SD satisfaction feedback

      get the Satisfaction date custom field id.

      SELECT id FROM customfield WHERE cfname  ='Satisfaction date'
      

      find and clone a row where `customfield` equals the ID we get from the last query.

      When running the JQL behind the satisfaction report and the defective issue is on the list, the error 500 returns.

              Unassigned Unassigned
              aromanenko ari (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: