Limit in CMIS query

cancel
Showing results for 
Search instead for 
Did you mean: 
plean
Active Member II

Limit in CMIS query

Jump to solution

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

1 Solution

Accepted Solutions
plean
Active Member II

Re: Limit in CMIS query

Jump to 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.

View solution in original post

4 Replies
janv
Alfresco Employee

Re: Limit in CMIS query

Jump to solution

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
Active Member II

Re: Limit in CMIS query

Jump to solution

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.cmisSmiley SurprisedbjectId = t.cmisSmiley SurprisedbjectId

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

Thank you,

André

plean
Active Member II

Re: Limit in CMIS query

Jump to 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
Alfresco Employee

Re: Limit in CMIS query

Jump to solution

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

Regards,

Jan