topic Re: Paging in NXQL in Nuxeo Forum

Paging in NXQL

SMAH_Haider — Wed, 02 May 2012 08:40:57 GMT

We have Nuxeo EP 5.5 deployed at one of our server. Our application that is deployed on another computer using Nuxeo webservices to search document against a search criteria. Now there may be 10,000 records against this search criteria because we are incorporating Nuxeo EP 5.5 with our enterprise application.

As we are using nuxeo webservices to interact with Nuxeo so we'll have to slice this huge response as we are displaying the result at our front end (application) page by page (10 rows per page.)

Nuxeo does provide:

DocumentModelList docs = session.query("SELECT * FROM DOCUMENT WHERE dc:title = '"+aTitle+"'").subList(fromIndex, toIndex);

to break the result to chunks.

I want to know does NXQL provide any paging support? I want to do this at query level to further speedup the response.

Re: Paging in NXQL

SMAH_Haider — Wed, 02 May 2012 09:15:44 GMT

some clause in NXQL?

Re: Paging in NXQL

Florent_Guillau — Wed, 02 May 2012 17:01:24 GMT

There are various different signatures for CoreSession.query(), some of which like this take limit/offset values. Make sure that you ORDER BY in your query to get consistent results, for instance ORDER BY ecm:uuid.

Re: Paging in NXQL

Florent_Guillau — Wed, 02 May 2012 17:02:53 GMT

Also you may want to consider using CoreSession.queryAndFetch for more efficient returning of lots of values if you're not directly interested in the DocumentModel itself.

Re: Paging in NXQL

SMAH_Haider — Wed, 02 May 2012 17:39:15 GMT

Perfect! exactly what I wanted. Thanks Florent.