topic Re: How to limit results from NXQL Query API REST in Nuxeo Forum

How to limit results from NXQL Query API REST

Domingo_Gonzále — Wed, 04 Jan 2017 12:16:12 GMT

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

Re: How to limit results from NXQL Query API REST

pibou_Bouvret — Wed, 04 Jan 2017 12:29:59 GMT

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

Re: How to limit results from NXQL Query API REST

Domingo_Gonzále — Wed, 04 Jan 2017 14:54:34 GMT

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

Re: How to limit results from NXQL Query API REST

pibou_Bouvret — Wed, 04 Jan 2017 16:00:51 GMT

Example CURL request

Re: How to limit results from NXQL Query API REST

Domingo_Gonzále — Thu, 05 Jan 2017 09:28:24 GMT

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

Re: How to limit results from NXQL Query API REST

Pierre-Gildas_M — Tue, 10 Jan 2017 15:24:09 GMT

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 ?