Hi Ricardo,

On May 30, 2013, at 10:54 PM, ricardo.julio.rodriguez.fernan...@sergas.es wrote:

> 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

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-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!!
_______________________________________________
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Reply via email to