topic Re: How can I find a number of documents ? in Nuxeo Forum

How can I find a number of documents ?

pwer21c_ — Fri, 08 Feb 2013 16:08:10 GMT

Hello, In nuxeo studio, after execution of nxql query, how can I get a number of results ?

ex : Execution of nxql query :

fetch > query : SELECT * FROM Document WHERE mydocumenttype:variable= DATE '@{CurrentDate.format("yyyy-MM-dd")}' and ecm:path='@{Document.parent.path}/'

And then,

number of results ?

Sincerely yours

Re: How can I find a number of documents ?

Laurent_Doguin — Wed, 13 Feb 2013 17:17:27 GMT

Hi,

after the query operation operation, the input for the next operation is a document list. So if you use for instance the Execution Context > Set Context Variable , you can put this as value: @{This.size()} This being the input of the operation.

Re: How can I find a number of documents ?

Florent_Guillau — Wed, 13 Feb 2013 17:55:13 GMT

Note that this is going to be quite slow as it returns all the documents. It would be better to use an operation based on the CoreSession.queryAndFetch API, but there isn't one today.

Re: How can I find a number of documents ?

pwer21c_ — Sat, 16 Feb 2013 09:11:59 GMT

thanks. Another question about this. If a query has not the result (NULL), nuxeo give me a error message or 0 ?

The last question is about convert string. How can I convert this integer type(this.size()) to string type in nuxeo studio ?

Thanks a lot

Re: How can I find a number of documents ?

Florent_Guillau — Sat, 16 Feb 2013 19:14:28 GMT

Please ask questions as new questions or updates to your original questions, not in the answers section.