[xwiki-users] Re : XWQL query on several objects of the same class instantiated in the same doc

________________________________________ 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 17:51 To: XWiki Users Subject: Re: [xwiki-users] XWQL query on several objects of the same class instantiated in the same doc Hi. I'm not sure I really understood what you need to do, but let me propose a solution anyway. I think what you need is to get the all the documents that contains comments with "%doc.title%" content and where there is NO comment with '%Withdrawal:2011% in the content. So, that's how I would solve the problem: #set ($xwlquery1 = "FROM doc.object(XWiki. XWikiComments) AS commWHERE doc.translation = 0 AND and comm.comment LIKE :doctitle AND doc.fullName NOT IN (SELECT doc2.fullName FROM Document doc2, doc2.object(XWiki.XWikiComments) comm2 WHERE comm2.comment LIKE '%Withdrawal:2011%')") #set($results = $services.query.xwql($xwqlquery1).bindValue('doctitle', "%${doc.title}%")) I didn't test it but it should work. Louis-Marie. 2013/5/22 &lt;Ricardo.Julio.Rodriguez.Fernandez(a)sergas.es&gt; > 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 &lt;ebeutler(a)synventis.com&gt; > > > >> 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