How can I find a number of documents ?

[pwer21c_]

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

[Laurent_Doguin · Accepted solution]

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.

[Florent_Guillau]

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.

[pwer21c_]

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

[Florent_Guillau]

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