Re: [xwiki-users] all pages without any "Tags"

2013-09-03 Thread Volker.Lapczynski
This is working on XWiki Enterprise 5.2-milestone-1: {{velocity}} #set($sql = ("where doc.fullName not in (select doc.fullName from XWikiDocument doc, BaseObject as tagObj, DBStringListProperty as tags join tags.list tag where doc.fullName = tagObj.name and tagObj.className = 'XWiki.TagClass' and

Re: [xwiki-users] all pages without any "Tags"

2013-09-03 Thread Vincent Massol
Hi, On Sep 3, 2013, at 5:26 PM, "Volker.Lapczynski" wrote: > This is working on XWiki Enterprise 5.2-milestone-1: Cool. Maybe you could contribute it as a snippet on extensions.xwiki.org? Thanks -Vincent > {{velocity}} > #set($sql = ("where doc.fullName not in (select doc.fullName from > XW

Re: [xwiki-users] all pages without any "Tags"

2013-09-03 Thread Marius Dumitru Florea
Try this $services.query.hql("where doc.fullName not in (select doc.fullName from XWikiDocument doc, BaseObject as tagObj, DBStringListProperty as tags join tags.list tag where doc.fullName = tagObj.name and tagObj.className = 'XWiki.TagClass' and tagObj.id = tags.id.id and tags.id.name='tags' and

[xwiki-users] all pages without any "Tags"

2013-09-03 Thread Volker.Lapczynski
How do i get all pages without any Tags? Tried this without luck: {{velocity}} #set($tagFilter = " and NOT IN elements(prop.list)") #set($sql = ", BaseObject as obj, DBStringListProperty as prop where obj.className='XWiki.TagClass' and obj.id=prop.id.id and prop.id.name='tags' ${tagFilter} order b