3 Sep
2013
3 Sep
'13
11:40 a.m.
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 by doc.fullName asc")
##set ($list = $xwiki.searchDocuments($sql))
#foreach($item in $xwiki.searchDocuments($sql))
[[$item]]
#end
{{/velocity}}
Volker/Oslo
--
View this message in context:
http://xwiki.475771.n2.nabble.com/all-pages-without-any-Tags-tp7586883.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
3 Sep
3 Sep
3:59 p.m.
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 tag <> '') order by
doc.fullName").setLimit(10).execute()
Hope this helps,
Marius
On Tue, Sep 3, 2013 at 12:40 PM, Volker.Lapczynski <vola(a)ahus.no> wrote:
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 by doc.fullName asc")
##set ($list = $xwiki.searchDocuments($sql))
#foreach($item in $xwiki.searchDocuments($sql))
[[$item]]
#end
{{/velocity}}
Volker/Oslo
--
View this message in context:
http://xwiki.475771.n2.nabble.com/all-pages-without-any-Tags-tp7586883.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
5:26 p.m.
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 tagObj.id = tags.id.id and tags.id.name='tags' and
tag
<> '')order by doc.space asc ") )
#set ($list = $xwiki.searchDocuments($sql))
#foreach($item in $xwiki.searchDocuments($sql))
#set ($recentDoc = $xwiki.getDocument($item).getTranslatedDocument())
## We use HTML here because we don't have a tool to escape wiki syntax in
document title.
|$recentDoc.getSpace()|{{html}} $escapetool.xml($recentDoc.plainTitle)
<$recentDoc.getURL()> {{/html}}
#end
{{/velocity}}
Thank You!
--
View this message in context:
http://xwiki.475771.n2.nabble.com/all-pages-without-any-Tags-tp7586883p7586…
Sent from the XWiki- Users mailing list archive at Nabble.com.
5:31 p.m.
Hi,
On Sep 3, 2013, at 5:26 PM, "Volker.Lapczynski" <vola(a)ahus.no> 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
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
tag
<> '')order by doc.space asc ") )
#set ($list = $xwiki.searchDocuments($sql))
#foreach($item in $xwiki.searchDocuments($sql))
#set ($recentDoc = $xwiki.getDocument($item).getTranslatedDocument())
## We use HTML here because we don't have a tool to escape wiki syntax in
document title.
|$recentDoc.getSpace()|{{html}} $escapetool.xml($recentDoc.plainTitle)
<$recentDoc.getURL()> {{/html}}
#end
{{/velocity}}
Thank You!
11 Dec
11 Dec
7:28 p.m.
New subject: [xwiki-users] RES: all pages without any "Tags"
Hello People,
Just to notify, I have tried this extension but it is not working. I don’t know why but
the consulting results still showing documents that have tags.
I am using the XWiki 5.2.2
Danilo
Grupo Energisa
Danilo A. Oliveira
Analista Suporte Aplicacao TI - DETI
e-mail: danilo.oliveira(a)energisa.com.br | tel: (32) 3429-6342
Esta mensagem contém informação confidencial. Se você a recebeu por engano, não divulgue
ou copie seu conteúdo. Por favor, avise ao remetente imediatamente e apague-a do
computador.
Privileged and confidential. If this message has been received by mistake, do not disclose
or copy its contents. Please notify sender and delete immediately.
-----Mensagem original-----
De: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] Em nome de Vincent Massol
Enviada em: terça-feira, 3 de setembro de 2013 12:32
Para: XWiki Users
Assunto: Re: [xwiki-users] all pages without any "Tags"
Hi,
On Sep 3, 2013, at 5:26 PM, "Volker.Lapczynski" <vola(a)ahus.no> 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
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 tag <> '')order by doc.space asc ") )
#set
($list = $xwiki.searchDocuments($sql)) #foreach($item in
$xwiki.searchDocuments($sql)) #set ($recentDoc =
$xwiki.getDocument($item).getTranslatedDocument())
## We use HTML here because we don't have a tool to escape wiki
syntax in document title.
|$recentDoc.getSpace()|{{html}} $escapetool.xml($recentDoc.plainTitle)
<$recentDoc.getURL()> {{/html}}
#end
{{/velocity}}
Thank You!
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
12 Dec
12 Dec
4:46 p.m.
New subject: [xwiki-users] RES: all pages without any "Tags"
Hello Danilo!
Thank you for your feedback.
I installed the extension again, both with "clip and paste" and installing
the xar. The results showing only documents without having tags. Se:
http://www.radiology.no/xwiki/bin/view/RadWiki/PagesWithoutTags
<http://www.radiology.no/xwiki/bin/view/RadWiki/PagesWithoutTags>
I am using the XWiki Enterprise 5.2.1
Volker
--
View this message in context:
http://xwiki.475771.n2.nabble.com/all-pages-without-any-Tags-tp7586883p7588…
Sent from the XWiki- Users mailing list archive at Nabble.com.
3931
days inactive
4031
days old
5 comments
5 participants
participants (5)
-
Danilo Amaral de Oliveira -
Legeinfo -
Marius Dumitru Florea -
Vincent Massol -
Volker.Lapczynski