[OPENJPA-490] JPQL extension: aggregates in ORDER BY

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9.0, 0.9.6, 0.9.7, 1.0.0, 1.0.1
• Fix Version/s: 1.1.0
• Assignee: Unassigned
• Reporter: Patrick Linskey
• Created: 16/Jan/08 02:21
• Updated: 09/Mar/10 18:32
• Resolved: 16/Jan/08 03:53

Description

JPQL only allows state fields in ORDER BY clauses. It is useful to order by aggregates when doing a GROUP BY as well. Example:

select sum(o.shortField) from AllFieldTypes o
group by o.intField
order by sum(o.shortField) asc