28 Mar
2014
28 Mar
'14
1:23 p.m.
On 27 Mar 2014 at 21:01:49, Jeremie BOUSQUET
(jeremie.bousquet@gmail.com(mailto:jeremie.bousquet@gmail.com)) wrote:
Hello,
Seems every year I hit this problem (ORDER BY COUNT in XWQL causes a parser
exception), so this time I decided to create an issue ... :) :
http://jira.xwiki.org/browse/XWIKI-10189
cool :)
<kidding>
Maybe you’ll be able to provide a patch next year! ;)
</kidding>
Thanks
-Vincent
BR,
Jeremie
2012-05-24 15:13 GMT+02:00 Jeremie BOUSQUET :
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() is valid
in JPQL ? As long as the expression is also present in the SELECT
clause.
Thanks,
Jeremie
2011/10/18 jerem
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
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
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users