nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Find more posts tagged with

Alfresco Content Services

Accepted answers

plean

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.

All comments

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

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