[jira] [Closed] (CAY-2004) EJBQL: Support for ordering on aggregate expressions

["Andrus Adamchik (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CAY-2004?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrus Adamchik closed CAY-2004.
--------------------------------
       Resolution: Fixed
    Fix Version/s: 4.0.M3

> EJBQL: Support for ordering on aggregate expressions
> ----------------------------------------------------
>
>                 Key: CAY-2004
>                 URL: https://issues.apache.org/jira/browse/CAY-2004
>             Project: Cayenne
>          Issue Type: Improvement
>            Reporter: Andrus Adamchik
>            Assignee: Andrus Adamchik
>             Fix For: 4.0.M3
>
>
> as of now EJBQLQuery is the only object query that supports data aggregation. Yet (according to the JPA spec that we've followed originally) we can no order query results on aggregated values. E.g. the following won't parse:
> select a, count(p) from Artist a INNER JOIN a.paintings p order by count(p) DESC
> Will need to add support for this feature to the grammar and runtime.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)