[xwiki-notifications] [Issue] Closed: (XWATCH-32) Taglist query not working on HSQLDB

[Jerome Velociter (JIRA)]

     [ http://jira.xwiki.org/jira/browse/XWATCH-32?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jerome Velociter closed XWATCH-32.
----------------------------------

    Fix Version/s: 1.0M3
       Resolution: Fixed

> Taglist query not working on HSQLDB
> -----------------------------------
>
>                 Key: XWATCH-32
>                 URL: http://jira.xwiki.org/jira/browse/XWATCH-32
>             Project: XWiki Watch
>          Issue Type: Bug
>          Components: Other
>    Affects Versions: 1.0M1
>            Reporter: Ludovic Dubost
>         Assigned To: Anca Paula Luca
>             Fix For: 1.0M3
>
>
> We need to use this query instead (which works on hsqldb and mysql)
> select elements(entry.tags), count(*) from XWiki.FeedEntryClass as entry, XWikiDocument as doc, BaseObject as obj where doc.fullName=obj.name and obj.id=entry.id and doc.web='${request.space}' group by col_0_0_

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.xwiki.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira