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

Hi Vicent! 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-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!!