On Mon, May 28, 2012 at 11:54 PM,
<Ricardo.Julio.Rodriguez.Fernandez(a)sergas.es> wrote:
>>>
________________________________________
>>> From: users-bounces(a)xwiki.org [users-bounces(a)xwiki.org] On Behalf Of Marius
Dumitru Florea [mariusdumitru.florea(a)xwiki.com]
>>> Sent: 28 May 2012 08:48
>>> To: XWiki Users
>>> Subject: Re: [xwiki-users] help with a query
>>>
>>> On Sun, May 27, 2012 at 10:29 AM,
<Ricardo.Julio.Rodriguez.Fernandez(a)sergas.es> wrote:
Hi!
________________________________________
From: users-bounces(a)xwiki.org [users-bounces(a)xwiki.org] On Behalf Of Sergiu Dumitriu
[sergiu(a)xwiki.com]
Sent: 27 May 2012 02:44
To: XWiki Users
Subject: Re: [xwiki-users] help with a query
On 05/26/2012 07:29 PM, Ricardo.Julio.Rodriguez.Fernandez(a)sergas.es wrote:
Sorry,
but I'm not able to get a query getting this:
All comments added to XWiki users.
> Do you want to get the comments themselves as
a whole, just the comment
> body, or just the name of the user documents where comments have been added?
I've found this...
http://extensions.xwiki.org/xwiki/bin/Extension/Get+Last+Comment
Coming from this thread...
http://xwiki.markmail.org/thread/qwnwzoa23ewdt64w
Sorry, I should have found it before!
it requires programming rigths, but this is not a
problem rigth now for us. What I'm not able to understand here is the role of
setLimit(1). Please, check this...
>>> setLimit sets the maximum number of
rows to return. In this case,
>>> since the snippet is showing the last comment, the query needs to
>>> return at most one row.
http://atriumkm.idisantiago.es/bin/ICT/ListCommentsWithProgrammingRights
We get the same result by using or not using it. Please, what am I missing here?
Also, whatever value I use for setLimit(), I
always get the first value in the list as ordered in the xwql statement.
>>> Maybe you changed the query in the
mean time, but I can see both
>>> comments displayed when you don't set the limit.
Thanks, Marius. No, I didn't change the query. Please, see this...
$services.query.xwql($xwlquery).setLimit(1).execute().get(0) First
$services.query.xwql($xwlquery).execute().get(0) First
Only First (comment) is displayed in both cases. The first code lines includes
setLimit(1) but the second one doesn't.
It's simple. execute() returns a list:
['First']
['First', 'Second']
In both cases, the first item in the list obtained with get(0) is
'First'. There's nothing wrong with that. setLimit() sets the maximum
size of the returned list. In the first case the list has maximum one
element, and in the second case it has the size equal with the number
of matching rows found in the database.
Hope this helps,
Marius
>>> Hope this helps,
>>> Marius
I would not be hard to apply this query to all desired documents by looping through them.
Please, is this the most effective/economic in terms of process work way of doing this
query?
Thank you so much for your help!!!
Please, could you help me?
Thank you very much,
Ricardo
--
Ricardo Rodríguez
Research Management and Promotion Technician
Technical Secretariat
Health Research Institute of Santiago de Compostela (IDIS)
http://www.idisantiago.es
Nota: A información contida nesta mensaxe e os seus posibles documentos adxuntos é
privada e confidencial e está dirixida únicamente ó seu destinatario/a. Se vostede non é
o/a destinatario/a orixinal desta mensaxe, por favor elimínea. A distribución ou copia
desta mensaxe non está autorizada.
Nota: La información contenida en este mensaje y sus posibles documentos adjuntos es
privada y confidencial y está dirigida únicamente a su destinatario/a. Si usted no es
el/la destinatario/a original de este mensaje, por favor elimínelo. La distribución o
copia de este mensaje no está autorizada.
See more languages:
http://www.sergas.es/aviso_confidencialidad.htm
--
Sergiu Dumitriu
http://purl.org/net/sergiu/
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
Nota: A información contida nesta mensaxe e os seus posibles documentos adxuntos é
privada e confidencial e está dirixida únicamente ó seu destinatario/a. Se vostede non é
o/a destinatario/a orixinal desta mensaxe, por favor elimínea. A distribución ou copia
desta mensaxe non está autorizada.
Nota: La información contenida en este mensaje y sus posibles documentos adjuntos es
privada y confidencial y está dirigida únicamente a su destinatario/a. Si usted no es
el/la destinatario/a original de este mensaje, por favor elimínelo. La distribución o
copia de este mensaje no está autorizada.
See more languages:
http://www.sergas.es/aviso_confidencialidad.htm
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
Nota: A información contida nesta mensaxe e os seus posibles documentos adxuntos é
privada e confidencial e está dirixida únicamente ó seu destinatario/a. Se vostede non é
o/a destinatario/a orixinal desta mensaxe, por favor elimínea. A distribución ou copia
desta mensaxe non está autorizada.
Nota: La información contenida en este mensaje y sus posibles documentos adjuntos es
privada y confidencial y está dirigida únicamente a su destinatario/a. Si usted no es
el/la destinatario/a original de este mensaje, por favor elimínelo. La distribución o
copia de este mensaje no está autorizada.
See more languages:
http://www.sergas.es/aviso_confidencialidad.htm
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users