On Mon, Aug 5, 2013 at 5:23 PM, Stephen Martin <SteveM(a)jonesmetal.com> wrote:
I want to modify the GlobalBlogRss feed to add a
couple of different
filters and have been able to do so successfully up to the final point.
I can't seem to get the syntax correct for limiting the results to a
specific xwikilistitem. The query string is passed to
xwiki.feed.getBlogFeedOutput. The query string that I am using is:
, DBStringListProperty as categories join categories.list as category,
BaseObject obj, IntegerProperty isPublished, IntegerProperty hidden,
DateProperty publishDate
where doc.fullName <> 'Blog.BlogPostTemplate' and
obj.name = doc.fullName and obj.className = 'Blog.BlogPostClass' and
publishDate.id.id = obj.id and publishDate.id.name = 'publishDate' and
isPublished.id.id = obj.id and isPublished.id.name = 'published' and
hidden.id.id = obj.id and hidden.id.name = 'hidden' and
(doc.creator = 'XWiki.stevem' or (isPublished.value = 1 and hidden.value
= 0)) and obj.id = categories.id.id and categories.id.name='category'
I would like to add the statement
[xwikilistitem].value='Blog.Production' but unclear of proper way to do
so.
Is another JOIN required?
I think you just have to add:
and category = 'Blog.Production'
The current 'join categories.list as category' should be enough.
Hope this helps,
Marius
Any pointers to reference material would be welcome as well.
Thanks,
Steve Martin
IT Support
Jones Metal
(740) 623-5102
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs