Hi Vicent! > ________________________________________ > From: users-boun...@xwiki.org [users-boun...@xwiki.org] On Behalf Of Vincent > Massol [vinc...@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.fernan...@sergas.es> > wrote: > >> Hi Vincent, all! >> >> Please, do you think this is of any value and clear enough as to going to >> XWiki Extensions Query Module page? >> >> http://www.idisantiago.es/bin/XWQL/QueryOnComments > > 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'") >
Thanks for the note, Vicent! I've already tried that, but I was not able to solve this error: Caused by: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: could not locate named parameter [string1] I've modified the code at the link below to show you the whole error message... http://www.idisantiago.es/bin/XWQL/QueryOnComments I read your reference to bind variables in http://extensions.xwiki.org/xwiki/bin/view/Extension/Query+Module, but I'm not able to find my error! Please, where am I wrong? I'm still working with a XE 2.4.30451 installation. Thanks! > And then: > > $services.query.xwql($xwqlquery).bindValue("string1", string1).execute() > > Thanks > -Vincent > >> >> Thanks! >> >> ________________________________________ >> From: users-boun...@xwiki.org [users-boun...@xwiki.org] On Behalf Of Vincent >> Massol [vinc...@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.fernan...@sergas.es >> wrote: >> >>> Hi! >>> >>>> ________________________________________ >>>> From: users-boun...@xwiki.org [users-boun...@xwiki.org] On Behalf Of >>>> BOUSQUET Jeremie [jeremie.bousq...@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!! 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 _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
