Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-10217

ORDER BY does not work with aggregate functions on XWQL

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.1
    • Fix Version/s: 6.0-rc-1
    • Component/s: Query
    • Labels:
    • Difficulty:
      Unknown
    • Documentation:
      N/A
    • Documentation in Release Notes:
      N/A
    • Similar issues:

      Description

      Like XWIKI-10189,
      this query does not work:

      SELECT obj.person, SUM(obj.money) FROM Document doc, doc.object(Test.TestClass) obj GROUP BY obj.person ORDER BY SUM(obj.money) DESC
      

      Same for: AVG, MAX, MIN.

        Attachments

          Activity

            People

            • Assignee:
              gdelhumeau Guillaume Delhumeau
              Reporter:
              gdelhumeau Guillaume Delhumeau
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: