/api/people retruens only 5000 users

diptikulkarni — Thu, 16 Apr 2015 07:45:15 GMT

hi , we have around 1 lac users users defined in Alfresco, and when we use api for people, we get only 5k users.Is it possible to get all users using some pagination parameter in API? couldnt find much online, and people talked about making backed change to Alfresco server.Please help.

Re: /api/people retruens only 5000 users

jm_pascal — Fri, 17 Apr 2015 12:46:26 GMT

Aloah,

You need to use the parameter maxResults like below

 
GET alfresco/service/api/people?maxResults=1
‍‍‍

Hope it helps.

Re: /api/people retruens only 5000 users

diptikulkarni — Wed, 22 Apr 2015 06:58:22 GMT

Thanks for your reply Aloah, Even after using maxResults=5000, we still gets 1k users in the result. i also found some one talked about changing the defaultListMaxResults in peoplescript bean like mentioned here http://stackoverflow.com/questions/18155016/alfresco-api-service-people-only-returns-5000-results-in-alfresco-ee-4-1-4?rq=1

Can you let us know how this should be done, and whether this is the only way to get all users

Re: /api/people retruens only 5000 users

deepak1987 — Sun, 26 Apr 2015 21:28:03 GMT

Hi Dipti,

You need to make the following changes in order to get userList > 5000 in the result:

defaultListMaxResults property value is hard-coded to 5000 in peopleScript bean (org.alfresco.repo.jscript.People) so even if you pass maxResults=6000 in the Webscript, it will return MAX 5000 only.

Override following bean by setting 'defaultListMaxResults' property value to 10000 or more and put this bean entry in your custom context XML file like /tomcat/shared/classes/alfresco/extension/custom-script-services-context.xml and Restart the Alfresco instance.

And use following URL to get all the users from DB:
http://localhost:8080/alfresco/service/api/people

If you pass 'filter' parameter in the URL then it will get Users by SOLR query which will return MAX 1000 users.
http://localhost:8080/alfresco/service/api/people?filter=*
OR
http://localhost:8080/alfresco/service/api/people?filter=NON_NULL



 <bean id="peopleScript" parent="baseJavaScriptExtension" class="org.alfresco.repo.jscript.People">
        <property name="extensionName">
            <value>people</value>
        </property>
        <property name="storeUrl">
            <value>${spaces.store}</value>
        </property>
        <property name="serviceRegistry">
            <ref bean="ServiceRegistry"/>
        </property>
        <property name="authorityDAO">
            <ref bean="authorityDAO"/>
        </property>
        <property name="authorityService">
            <ref bean="AuthorityService"/>
        </property>
        <property name="personService">
            <ref bean="PersonService"/>
        </property>
        <property name="authenticationService">
            <ref bean="AuthenticationService"/>
        </property>
        <property name="contentUsageService">
            <ref bean="ContentUsageService"/>
        </property>
        <property name="tenantService">
            <ref bean="tenantService"/>
        </property>
        <property name="userNameGenerator">
            <ref bean="userNameGenerator"/>
        </property>
        <property name="userRegistrySynchronizer" ref="userRegistrySynchronizer" />
        <property name="honorHintUseCQ">
            <value>${people.search.honor.hint.useCQ}</value>
        </property>
       
         <!– NEW property added to set the defaultListMaxResults value –>
        <property name="defaultListMaxResults">
            <value>10000</value>
        </property>
          
    </bean>

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

topic /api/people retruens only 5000 users in Alfresco Archive

/api/people retruens only 5000 users

Re: /api/people retruens only 5000 users

Re: /api/people retruens only 5000 users

Re: /api/people retruens only 5000 users