22 May
2013
22 May
'13
5:26 p.m.
Hi! Thanks you both for answering!
I'm afraid that your proposals didn't solve the problem. Please, see here...
http://www.idisantiago.es/bin/XWQL/SnapshotE0012012
Both users have three comments each. This way:
XWD_ID:416379378
Gender:xxxxxxxx
Withdrawal:20121017
Formely:XWiki.XWikiIDISE001
XWD_ID:946660794
Gender:xxxxxxxx
Withdrawal:20111231
Formely:XWiki.XWikiIDISE001
Thus, I'm still not able to design a query to retrive ONLY user XWD_ID:416379378 based
on comments :-( Your proposals answer with a list including both users n times. I'm
not able neither of explain n in both cases... any idea will be welcome!
Thank you very much for your help,
Ricardo
________________________________________
From: users-bounces(a)xwiki.org [users-bounces(a)xwiki.org] On Behalf Of Guillaume
"Louis-Marie" Delhumeau [gdelhumeau(a)xwiki.com]
Sent: 22 May 2013 13:02
To: XWiki Users
Subject: Re: [xwiki-users] XWQL query on several objects of the same class instantiated
in the same doc
Hi Ricardo and Edo,
2013/5/22 Edo Beutler <ebeutler(a)synventis.com>
Nota: A información contida nesta mensaxe e os seus posibles documentos adxuntos é privada
e confidencial e está dirixida únicamente ó seu destinatario/a. Se vostede non é o/a
destinatario/a orixinal desta mensaxe, por favor elimínea. A distribución ou copia desta
mensaxe non está autorizada.
Nota: La información contenida en este mensaje y sus posibles documentos adjuntos es
privada y confidencial y está dirigida únicamente a su destinatario/a. Si usted no es
el/la destinatario/a original de este mensaje, por favor elimínelo. La distribución o
copia de este mensaje no está autorizada.
See more languages: http://www.sergas.es/aviso_confidencialidad.htm
Hi Ricardo
You are only checking in one object. So there has to be one object that
contains the doc name, but not the withdrawal part which is fulfilled by
the third object in your example. Whilst I don't recall ever having tried
checking for multiple objects in XWQL, I would suspect this should work:
#set ($xwlquery1 = "from doc.object(XWiki.XWikiComments) as comm1,
doc.object(XWiki.XWikiComments) as comm2 where doc.translation = 0 and
comm1.comment like '%$doc.title%' and comm2.comment not like
'%Withdrawal:2011%'")
You are right. But I think you should add "comm1 <> comm2" in your query
to
make it work.
Louis-Marie
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users