cancel
Showing results for 
Search instead for 
Did you mean: 

How to limit results from NXQL Query API REST

Domingo_Gonzále
Confirmed Champ
Confirmed Champ

Hi, I don't know how I can LIMIT the number of results from a NXQL query. Any Idea? If the query returns me 200 results I want only 20 ,for example. Mi Nuxeo's version is 5.8 Can I do this? Thanks Regards

5 REPLIES 5

pibou_Bouvret
Elite Collaborator
Elite Collaborator

Whether you use the REST API endpoint (/query/) or the automation operation (Repository.Query), you have a pageSize parameter (and currentPageIndex)

Domingo_Gonzále
Confirmed Champ
Confirmed Champ

$lo_answer = $lo_session->newRequest("Document.Query") ->set('params', 'query', $nxqlQuery) ->set('pageSize', 1) ->setSchema('*') ->sendRequest();

like that? not working ...

I also tried to do:

$lo_answer = $lo_session->newRequest("Document.Query")
->set('params', 'query', $nxqlQuery)
->set('params','pageSize', 1)
->setSchema('*')
->sendRequest();

and does not...



Example CURL request

Domingo_Gonzále
Confirmed Champ
Confirmed Champ

I have been looking at "Api Playground" and I can not find the way to limit the results, now I try to do it but there is no file in the repository and I do not know how to upload it. In the automation of php I introduce the parameters that should make the effect that I want in the query and it does not produce an error but it does not limit the results either

Getting started

Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.