cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrus Adamchik (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CAY-2004) EJBQL: Support for ordering on aggregate expressions
Date Fri, 17 Apr 2015 11:14:58 GMT
Andrus Adamchik created CAY-2004:
------------------------------------

             Summary: 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


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)

Mime
View raw message