Alfresco CMIS Query returning only 100 results?

[dynamolalit]

I am using alfresco 4.2 EE & trying to get search results using CMIS query

select * from cmis:document where cmis:name not like '%.ftl%' and 
cmis:contentStreamLength>0
‍‍‍‍

I am able to search the content but it is returning only 100 results not more that that. I tired to configure for more results as below but of no use.

# The maximum time spent pruning results
system.acl.maxPermissionCheckTimeMillis=1000000
# The maximum number of search results to perform permission checks against
system.acl.maxPermissionChecks=100000
‍‍‍‍‍‍

Can anyone help here to get more results?

[abarisone]

Hi,
take a look here:
http://stackoverflow.com/questions/14817414/alfresco-cmis-limit-size-and-time-query
http://mail-archives.apache.org/mod_mbox/chemistry-dev/201110.mbox/%3C5843_1317719934_4E8ACF7E_5843_...
http://forums.alfresco.com/forum/developer-discussions/alfresco-api/cmis-query-maximum-results-02232...

Hope these help.

Regards,
Andrea

[dynamolalit]

Thanks,

Is there any way to set 

<maxItems>‍

into alfresco repository properties file or in any xml?

[abarisone]

Hi,
I think this is the right post you need to carefully read https://forums.alfresco.com/forum/developer-discussions/technical-architecture-discussion/limitation...
You have to try modifications on the file

tomcat\webapps\alfresco\WEB-INF\classes\alfresco\repository.properties‍

Regards,
Andrea

[dynamolalit]

I have already updated these parameters as in my previous post.

# The maximum time spent pruning results
system.acl.maxPermissionCheckTimeMillis=1000000
# The maximum number of search results to perform permission checks against
system.acl.maxPermissionChecks=100000
‍‍‍‍‍‍

[abarisone]

Ok,
but as also stated here http://fcorti.com/2013/05/01/alfresco-1000-results-lucene/ this should be right thing to do.

Regards,
Andrea

[dynamolalit]

I am already using Solr but not lucene. Anyways i have tried but without any success. It seems more to kind of bug/enhancement in alfresco. I have raised this @ <a> https://issues.alfresco.com/jira/browse/ALF-20766?page=com.atlassian.jira.plugin.system.issuetabpane...</a>