That works! I thought I did that earlier but evidently I hadn't. Thanks!
--Steve
-----Original Message-----
From: devs-bounces(a)xwiki.org [mailto:devs-bounces@xwiki.org] On Behalf
Of Marius Dumitru Florea
Sent: Tuesday, August 06, 2013 7:55 AM
To: XWiki Developers
Subject: Re: [xwiki-devs] Retrieving xwikilistitems
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
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs