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.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
Re: [xwiki-users] XWQL query on several objects of the same class instantiated in the same doc
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-boun...@xwiki.org [users-boun...@xwiki.org] On Behalf Of Vincent Massol [vinc...@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.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
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.fernan...@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-boun...@xwiki.org [users-boun...@xwiki.org] On Behalf Of Vincent Massol [vinc...@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.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
Re: [xwiki-users] XWQL query on several objects of the same class instantiated in the same doc
See also http://playground.xwiki.org/xwiki/bin/view/Main/Vincent Thanks -Vincent On May 31, 2013, at 9:26 AM, Vincent Massol vinc...@massol.net 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, ricardo.julio.rodriguez.fernan...@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-boun...@xwiki.org [users-boun...@xwiki.org] On Behalf Of Vincent Massol [vinc...@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.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,
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-boun...@xwiki.org [users-boun...@xwiki.org] On Behalf Of Vincent Massol [vinc...@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.fernan...@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-boun...@xwiki.org [users-boun...@xwiki.org] On Behalf Of Vincent Massol [vinc...@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.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
[xwiki-users] [ANN] XWiki 5.1 Milestone 1 Released
The XWiki development team is proud to announce the availability of XWiki 5.1 Milestone 1. This release brings an improved Solr search UI with faceted search and a couple of bug fixes and other small improvements. You can download it here: http://www.xwiki.org/xwiki/bin/view/Main/Download Make sure to review the release notes: http://www.xwiki.org/xwiki/bin/view/ReleaseNotes/ReleaseNotesXWiki51M1 Thanks -The XWiki dev team ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] XWQL query on several objects of the same class instantiated in the same doc
On May 31, 2013, at 10:50 AM, ricardo.julio.rodriguez.fernan...@sergas.es 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: users-boun...@xwiki.org [users-boun...@xwiki.org] On Behalf Of Vincent Massol [vinc...@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.fernan...@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-boun...@xwiki.org [users-boun...@xwiki.org] On Behalf Of Vincent Massol [vinc...@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.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:
[xwiki-users] problem with panels
Hi! I have a problem with the display of my panels. I have several panels in the Panels Organizer of my space Blog and I tried to drag and drop a panel TestPanel in the left-side column of the screen. When I checked the result in the Blog, I saw that the displayed panel was the one just before TestPanel in the Panels Organizer's list ! This problem occurs each time I try to do this. I need help please. Thanks Pierrick ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
[xwiki-users] Stuck on First Page of XWiki Distribution Wizard
Hello. I have just installed a new XWiki site. I did a manual war file deployment. When I logon as Admin I am brought to the XWiki Distribution Wizard. There are three choices at the bottom of the wizard: CONTINUE, SKIP, and CANCEL. Clicking any of the three buttons brings me back to the very same page. In other words, I'm stuck on the first page. Nothing is logged on the server side. The server is behind a corporate firewall and can only access the Internet through a proxy. Does anyone know what I must do to complete the Distribution Wizard? Thanks! -- View this message in context: http://xwiki.475771.n2.nabble.com/Stuck-on-First-Page-of-XWiki-Distribution-Wizard-tp7585532.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] XWQL query on several objects of the same class instantiated in the same doc
Thanks! Here you have our very small contribution... http://extensions.xwiki.org/xwiki/bin/view/Extension/XWQL+Query+on+comments Thanks for your work and your help! From: users-boun...@xwiki.org [users-boun...@xwiki.org] On Behalf Of Vincent Massol [vinc...@massol.net] Sent: 31 May 2013 16:20 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 On May 31, 2013, at 10:50 AM, ricardo.julio.rodriguez.fernan...@sergas.es 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: users-boun...@xwiki.org [users-boun...@xwiki.org] On Behalf Of Vincent Massol [vinc...@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.fernan...@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-boun...@xwiki.org [users-boun...@xwiki.org] On Behalf Of Vincent Massol [vinc...@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.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
Re: [xwiki-users] Stuck on First Page of XWiki Distribution Wizard
Hello, Did you setup proxy configuration in you servlet container or related user account? Arnaud. 2013/5/31 chtjfi john.william.fitzpatr...@gmail.com Hello. I have just installed a new XWiki site. I did a manual war file deployment. When I logon as Admin I am brought to the XWiki Distribution Wizard. There are three choices at the bottom of the wizard: CONTINUE, SKIP, and CANCEL. Clicking any of the three buttons brings me back to the very same page. In other words, I'm stuck on the first page. Nothing is logged on the server side. The server is behind a corporate firewall and can only access the Internet through a proxy. Does anyone know what I must do to complete the Distribution Wizard? Thanks! -- View this message in context: http://xwiki.475771.n2.nabble.com/Stuck-on-First-Page-of-XWiki-Distribution-Wizard-tp7585532.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
