[ https://issues.apache.org/jira/browse/OPENJPA-730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Michael Dick resolved OPENJPA-730.
----------------------------------
Resolution: Later
Since the issue is a question, and unfortunately the answer is no, I'm resolving the issue.
If this is a useful feature to add please re-open and mark as a New Feature. Thanks.
> 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.
|