See also http://playground.xwiki.org/xwiki/bin/view/Main/Vincent Thanks -Vincent On May 31, 2013, at 9:26 AM, Vincent Massol <[email protected]> wrote:
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?
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...
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!!