On May 31, 2013, at 10:50 AM, [email protected] wrote:
> 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? Done, see http://extensions.xwiki.org/xwiki/bin/view/Extension/Query+Module Thanks -Vincent > > http://www.idisantiago.es/bin/XWQL/QueryOnComments > > I'll copy it to the snippet's repository ASAP! > > Cheers! > > Ricardo > > > ________________________________________ > From: [email protected] [[email protected]] On Behalf Of Vincent > Massol [[email protected]] > 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, <[email protected]> > 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: [email protected] [[email protected]] On Behalf Of Vincent >> Massol [[email protected]] >> 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, [email protected] >> wrote: >> >>> Hi Vicent! >>> >>>> ________________________________________ >>>> From: [email protected] [[email protected]] On Behalf Of >>>> Vincent Massol [[email protected]] >>>> 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, <[email protected]> >>>> 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: [email protected] [[email protected]] On Behalf Of >>>>> Vincent Massol [[email protected]] >>>>> 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, [email protected] >>>>> wrote: >>>>> >>>>>> Hi! >>>>>> >>>>>>> ________________________________________ >>>>>>> From: [email protected] [[email protected]] On Behalf Of >>>>>>> BOUSQUET Jeremie [[email protected]] >>>>>>> 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!! _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
