topic Re: Alfresco CMIS Query returning only 100 results? in Alfresco Archive

Alfresco CMIS Query returning only 100 results?

dynamolalit — Fri, 17 Jan 2014 06:21:44 GMT

I am using alfresco 4.2 EE & trying to get search results using CMIS queryselect * 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 resu

Re: Alfresco CMIS Query returning only 100 results?

abarisone — Fri, 17 Jan 2014 07:46:47 GMT

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_4730_1_8AF751CD48F5A14AADA5E935BB6A406501EBBB59626B@THSONEA01CMS03P.one.grp%3E
http://forums.alfresco.com/forum/developer-discussions/alfresco-api/cmis-query-maximum-results-02232012-0830

Hope these help.

Regards,
Andrea

Re: Alfresco CMIS Query returning only 100 results?

dynamolalit — Fri, 17 Jan 2014 08:53:00 GMT

Thanks,

Is there any way to set

<maxItems>‍

into alfresco repository properties file or in any xml?

Re: Alfresco CMIS Query returning only 100 results?

abarisone — Fri, 17 Jan 2014 09:15:00 GMT

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

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

Regards,
Andrea

Re: Alfresco CMIS Query returning only 100 results?

dynamolalit — Fri, 17 Jan 2014 10:02:25 GMT

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
‍‍‍‍‍‍

Re: Alfresco CMIS Query returning only 100 results?

abarisone — Fri, 17 Jan 2014 10:43:00 GMT

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

Re: Alfresco CMIS Query returning only 100 results?

dynamolalit — Tue, 21 Jan 2014 07:04:52 GMT

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.issuetabpanels:all-tabpanel</a>