Author: lucaa
Date: 2007-12-11 17:46:05 +0100 (Tue, 11 Dec 2007)
New Revision: 6341
Modified:
xwiki-products/xwiki-watch/trunk/wiki/src/main/resources/WatchQueries/ArticleNumber
Log:
XWATCH-82: updated the ArticleNumber query to return all the feeds, including
the one with 0 unread articles.
Modified:
xwiki-products/xwiki-watch/trunk/wiki/src/main/resources/WatchQueries/ArticleNumber
===================================================================
---
xwiki-products/xwiki-watch/trunk/wiki/src/main/resources/WatchQueries/ArticleNumber
2007-12-11 16:24:12 UTC (rev 6340)
+++
xwiki-products/xwiki-watch/trunk/wiki/src/main/resources/WatchQueries/ArticleNumber
2007-12-11 16:46:05 UTC (rev 6341)
@@ -53,5 +53,5 @@
<tags/>
</property>
</object>
-<content>select entry.feedname, 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}' and (entry.read is null or
entry.read=0) group by entry.feedname</content>
+<content>select entry.feedname, sum(1-coalesce(entry.read,0)) 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 entry.feedname</content>
</xwikidoc>
_______________________________________________
notifications mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/notifications
