topic Re: Limit in CMIS query in Alfresco Forum

Limit in CMIS query

plean — Thu, 22 Mar 2018 08:52:46 GMT

Hello,I have a CMIS query which should give me hundrets of results. Unfortuntely it stops after 94 records. What can I do to get all the results? Unfortunately I really need to get all of them at once.Any help will be largely appreciated.Sincerly,André Pletschette

Re: Limit in CMIS query

janv — Thu, 22 Mar 2018 09:04:54 GMT

Hi André,

We will need more details 🙂

What exact build / version of ACS (Alfresco Content Services) Repository are you using ?

Can you please post your exact CMIS query ? You may need to log / debug to see whether it executes via DB (TMDQ) or Search Index ?

Have you tried running the same query via CMIS workbench ?

Are you using the CMIS browser-based (json) protocol binding or one of the other two (AtomPub or SOAP) ?

Regards,

Jan

Re: Limit in CMIS query

plean — Thu, 22 Mar 2018 10:48:44 GMT

Hello, thanks for your reply.

I did now test in CMIS Workbench, there I see an option "Max hits", when I put 1.000, I get 167 records. If I use it by Drupal CMIS module, I only get a limited subset. I will have to show further for your other questions. But it would be interesting to know how CMIS Worbench sends the "Max hits" to CMIS.

My Query:

select d.*, t.* from cmis:document as d join cm:titled as t on d.cmisbjectId = t.cmisbjectId

where d.cmis:name LIKE 'CT-%' ORDER BY d.cmis:name ASC

Thank you,

André

Re: Limit in CMIS query

plean — Thu, 22 Mar 2018 11:21:30 GMT

In fact the limit is not 94, but 100. The test where I got 94 was a more restricted query.

I finally found the solution to my problem at:

cmis/query more than 10 records [#2442141] | Drupal.org

So I just need to set $options = array('maxItems' => "1000") to cmisapi_query.

Re: Limit in CMIS query

janv — Fri, 23 Mar 2018 08:17:06 GMT

Thanks for the update. I'm glad you solved it.

Regards,

Jan