Details
-
Bug
-
Resolution: Fixed
-
Minor
-
5.1
-
Unknown
-
N/A
-
N/A
-
Description
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 an org.xwiki.query.jpql.parser.ParserException exception when executed.
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
In JPQL this would be allowed normally, and it could be useful to have it in XWQL.