Hello, Seems I'm back to this problem (XWiki 3.5), and I did not find a solution still ... For example this XWQL request : select topic.author, count(topic.author) from Document doc, doc.object(MailArchiveCode.MailTopicClass) as topic where doc.space<>'MailArchiveCode' group by topic.author order by count(topic.author) desc ... will throw this exception when executed : Caused by: org.xwiki.query.jpql.parser.ParserException: [1,165] expecting: id at org.xwiki.query.jpql.parser.Parser.parse(Parser.java:1247) at org.xwiki.query.jpql.internal.JPQLParser.parse(JPQLParser.java:46) at org.xwiki.query.xwql.internal.hql.XWQLtoHQLTranslator.translate(XWQLtoHQLTranslator.java:55) at org.xwiki.query.xwql.internal.XWQLQueryExecutor.execute(XWQLQueryExecutor.java:78) ... 123 more Column 165 refers to the count in the order by clause. This does not work better : select topic.author, count(topic.author) from Document doc, doc.object(MailArchiveCode.MailTopicClass) as topic where doc.space<>'MailArchiveCode' group by topic.author order by 2 desc It does not work with a MySQL nor HSQLDB default db. If I remove the order by clause, the query works correctly. I think it's strange because for me ORDER BY COUNT(<column>) is valid in JPQL ? As long as the expression is also present in the SELECT clause. Thanks, Jeremie 2011/10/18 jerem <[email protected]>
Hi,
I'm trying to use XWQL query language to select count of authors and would like to order this by descending order of this count.
I ended up having this work fine :
"select count(myobject.author), myobject.author from Document as doc, doc.object(Space.MyClass) as myobject group by myobject.author"
But adding " order by count(myobject.author) desc" leads to an error for translating the query ... Adding "AS" in the select expression does not seem to work either.
Is this possible in XWQL and how ?
Thanks, Jeremie
-- View this message in context: http://xwiki.475771.n2.nabble.com/XWQL-order-by-count-tp6904819p6904819.html Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users