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

[Anca Paula Luca (JIRA)]

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

Anca Paula Luca reassigned XWATCH-32:
-------------------------------------

    Assignee: Anca Paula Luca

> 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
>
> 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