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

Thanks Vincent! The evil were in the XWQL sentence: it read ':string1' instead of :string1. Could it be useful to add an XWQL sentence example to the Query Module page or a link to a page explaining the syntax to avoid this kind of errors?

http://www.idisantiago.es/bin/XWQL/QueryOnComments I'll copy it to the snippet's repository ASAP! Cheers! Ricardo ________________________________________ From: users-bounces(a)xwiki.org [users-bounces(a)xwiki.org] On Behalf Of Vincent Massol [vincent(a)massol.net] Sent: 31 May 2013 09:26 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 Try this: #set ($xwqlquery = "SELECT doc2.fullName FROM Document doc2, doc2.object(XWiki.XWikiComments) comm2 WHERE doc2.translation = 0 and comm2.comment LIKE :string1") #set ($results = $services.query.xwql($xwqlquery).bindValue("string1","test").execute()) Thanks -Vincent On May 31, 2013, at 9:14 AM, <Ricardo.Julio.Rodriguez.Fernandez(a)sergas.es> wrote: > Hi Vicent! > > Sorry for top-replying, but this email client is a PITA! > > Something else must be failing, this alternatives don't work neither: > > #set ($xwqlquery = "SELECT doc2.fullName FROM Document doc2, doc2.object(XWiki.XWikiComments) comm2 WHERE doc2.translation = 0 and comm2.comment LIKE ':string1'") > #set ($results = $services.query.xwql($xwqlquery).bindValue("string1",$string1).execute()) > > #set ($xwqlquery = "SELECT doc2.fullName FROM Document doc2, doc2.object(XWiki.XWikiComments) comm2 WHERE doc2.translation = 0 and comm2.comment LIKE ':string1'") > #set ($results = $services.query.xwql($xwqlquery).bindValue("string1",'$string1').execute()) > > #set ($xwqlquery = "SELECT doc2.fullName FROM Document doc2, doc2.object(XWiki.XWikiComments) comm2 WHERE doc2.translation = 0 and comm2.comment LIKE ':string1'") > #set ($results = $services.query.xwql($xwqlquery).bindValue("string1","$string1").execute()) > > I always get the same error... > > Caused by: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute > Wrapped Exception: could not locate named parameter [string1] > > Any idea will be welcome! > > Thanks! > > ________________________________________ > From: users-bounces(a)xwiki.org [users-bounces(a)xwiki.org] On Behalf Of Vincent Massol [vincent(a)massol.net] > Sent: 31 May 2013 08:15 > 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 30, 2013, at 10:54 PM, Ricardo.Julio.Rodriguez.Fernandez(a)sergas.es wrote: > >> Hi Vicent! >> >>> ________________________________________ >>> 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: >>> >>>> 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 > > It's easy, you've used string1 instead of $string1 in bindValue()… :) > > Thanks > -Vincent > >> 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!!