[jira] Created: (OPENJPA-730) Error when I add "ORDER BY count(f.report.id)" to my query

[teto (JIRA)]

Error when I add "ORDER BY count(f.report.id)"  to my query
-----------------------------------------------------------

                 Key: OPENJPA-730
                 URL: https://issues.apache.org/jira/browse/OPENJPA-730
             Project: OpenJPA
          Issue Type: Question
          Components: query
    Affects Versions: 1.0.0
         Environment: WIN
            Reporter: teto


I'm getting error when i added  "ORDER BY count(column) " to my  JPQL query.

 ERROR:
----------------
<openjpa-1.0.0-r420667:568756 nonfatal user error> 
org.apache.openjpa.persistence.ArgumentException: An error occurred while 
parsing the query filter 'SELECT  f.report.id FROM FavReports f, User u, Report 
r WHERE f.report.id=r.id and  f.user.id = u.id and UPPER(u.userName)= 
UPPER('USERNAME1') GROUP BY f.report.id  ORDER BY count(f.report.id) DESC'. 
Error message: <openjpa-1.0.0-r420667:568756 nonfatal user error> 
org.apache.openjpa.kernel.jpql.ParseException: Encountered "count" at character 
175, but expected: [<IDENTIFIER>].
        at 
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.parse(JPQLExpressionBuilder.java:1666)

++++++++++++++++++++++
The query :
------------
String jpql = "SELECT  f.report.id FROM FavReports f, User u, Report r WHERE 
f.report.id=r.id and  f.user.id = u.id and UPPER(u.userName)= UPPER('" + 
userName
                                + "') GROUP BY f.report.id  ORDER BY 
count(f.report.id) DESC";


Does JPQL support the  ORDER BY COUNT(id)   ????????


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.