Limit in CMIS query

[plean]

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

[janv]

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

[plean]

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é

[plean · Accepted solution]

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.

[janv]

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

Regards,

Jan