How to limit results from NXQL Query API REST

[Domingo_Gonzále]

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

[pibou_Bouvret]

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

[Domingo_Gonzále]

$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...

[pibou_Bouvret]

Example CURL request

[Domingo_Gonzále]

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

[Pierre-Gildas_M]

Hi, the following code works fine for me:

$client = new \Nuxeo\Automation\Client\NuxeoPhpAutomationClient('http://nuxeo:8080/nuxeo/site/automation');
$session = $client->getSession('Administrator', 'Administrator');
$docs = $session->newRequest('Document.Query')
  ->set('params', 'query', 'SELECT * FROM Document WHERE ecm:path STARTSWITH "/default-domain/workspaces/Default Workspace"')
  ->set('params', 'pageSize', 1)
  ->setSchema('*')
  ->sendRequest();

Can you share the NXQL query you use ?