nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Find more posts tagged with

Accepted answers

Laurent_Doguin

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.

All comments

Laurent_Doguin

Hi,

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.