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

ordering by multiple CFs with same name result in generating invalid JQL

XMLWordPrintable

      1. Restore the attached test.xml
      2. login as admin
      3. execute jql query: ORDER BY NF
      4. notice that the result orders both NF custom fields in ascending order and both have arrows. It has been decided that we'll leave that as it is.
      5. Click the column heading for the second NF field to make it sort DESC.
      6. notice that the query has been changed to: "ORDER BY cf[10005] DESC, NF". technicallyl this means that cf[10005] is listed twice since it is also part of NF.
      7. go to View Filter: the summary says "Sorted by: NF descending, then NF ascending, then NF ascending" which isn't correct.
      8. click Edit Filter: now you get an error message saying that query is invalid.

      We shouldn't generate invalid queries from a user clicking on the column headings.

        1. test.xml
          77 kB

              mtokar Michael Tokar
              jpendleton Justus Pendleton (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved:

                  Estimated:
                  Original Estimate - 6h
                  6h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 4.5h Time Not Required
                  4.5h