Re: [xwiki-users] 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 Vincent Massol [vincent(a)massol.net] Sent: 28 May 2013 08:45 To: XWiki Users Cc: Lista Garcia, Isabel Subject: Re: [xwiki-users] XWQL query on several objects of the same class instantiated in the same doc Hi Ricardo, On May 28, 2013, at 7:35 AM, <Ricardo.Julio.Rodriguez.Fernandez(a)sergas.es> wrote: Yes it would be great to add this to extensions.xwiki.org :) Since it's not a single query I'm not sure the best place is the query module page. I'd say that it could be added as an entire snippet on extensions.xwiki.org. Important Note: Your code is written dangerously and is subject to XSS attacks. You need to modify it and use binding: #set ($xwqlquery = "SELECT doc2.fullName FROM Document doc2, doc2.object(XWiki.XWikiComments) comm2 WHERE doc2.translation = 0 and comm2.comment LIKE '$string1'") should be: #set ($xwqlquery = "SELECT doc2.fullName FROM Document doc2, doc2.object(XWiki.XWikiComments) comm2 WHERE doc2.translation = 0 and comm2.comment LIKE ':string1'")

And then: $services.query.xwql($xwqlquery).bindValue("string1", string1).execute() Thanks -Vincent > > Thanks! > > ________________________________________ > From: users-bounces(a)xwiki.org [users-bounces(a)xwiki.org] On Behalf Of Vincent Massol [vincent(a)massol.net] > Sent: 23 May 2013 08:09 > To: XWiki Users > Cc: Lista Garcia, Isabel > Subject: Re: [xwiki-users] XWQL query on several objects of the same class instantiated in the same doc > > Getting closer :) > > Ricardo, when you resolve this, it would be great if you could add an example on > http://extensions.xwiki.org/xwiki/bin/view/Extension/Query+Module so that next time someone has the same question he/she can find some example of nested query there. > > Thanks > -Vincent > > On May 23, 2013, at 1:36 AM, Ricardo.Julio.Rodriguez.Fernandez(a)sergas.es wrote: > >> Hi! >> >>> ________________________________________ >>> From: users-bounces(a)xwiki.org [users-bounces(a)xwiki.org] On Behalf Of BOUSQUET Jeremie [Jeremie.BOUSQUET(a)gemalto.com] >>> Sent: 22 May 2013 22:38 >>> To: XWiki Users >>> Cc: Lista Garcia, Isabel >>> Subject: [xwiki-users] Re : XWQL query on several objects of the same class instantiated in the same doc >>> >>> Hi, >>> >>> You miss the .execute() at the end :) >>> >> >> Call me stupid! Thanks, Jeremie! Thanks Louis-Marie and Ebo! >> >> But I'm afraid I'm still not able to run the script without errors. It seems to me that the XWQL query... >> >> SELECT doc2.fullName FROM Document doc2, doc2.object(XWiki.XWikiComments) comm2 >> WHERE comm2.comment LIKE '%Withdrawal:2011%' >> >> doesn't generate a suitable list to enter in a NOT In construct. It generates this... >> >> [XWiki.MariaCerezo, XWiki.RodrigoCabanasGancedo, XWiki.JeronimoFortezaVila, ...] >> >> >> 'XWiki.MariaCerezo', 'XWiki.RodrigoCabanasGancedo', 'XWiki.JeronimoFortezaVila', ... >> >> At the bottom of the page... >> >> http://www.idisantiago.es/bin/XWQL/SnapshotE0012012 >> >> ... you'll find the error and the script split into several code chunks working perfectly. >> >> Please, am I right with the source of the problem? How could I change to the 'item','item2',ìtem3'... >> >> How could I change the way XWQL gives layout to the list? >> >> Thank you very much!!