topic Get all users of alfresco on java action in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/get-all-users-of-alfresco-on-java-action/m-p/57577#M20681 <HTML><HEAD></HEAD><BODY><P>Hi, i need to retrieve all the users of alfresco on a java action here the code i use :</P><P></P><P>&nbsp;&nbsp; private NodeService nodeService;<BR />&nbsp;&nbsp; &nbsp;private OwnableService ownableService;<BR />&nbsp;&nbsp; &nbsp;private PersonService personService;<BR />&nbsp;&nbsp; &nbsp;private PermissionService permissionService;<BR />&nbsp;&nbsp; &nbsp;private AuthorityService authorityService;</P><P></P><P></P><P>@Override<BR />&nbsp;protected void executeImpl(Action action, NodeRef actionedUponNodeRef)&nbsp; {<BR /><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PagingResults&lt;PersonInfo&gt; users = </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;personService.getPeople(</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"*", </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;new ArrayList&lt;QName&gt;(), </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;new ArrayList&lt;Pair&lt;QName,Boolean&gt;&gt;(), </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;new PagingRequest(personService.countPeople())</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);</STRONG></P><P><BR />&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;logger.info("The number of users in the system: " + personService.countPeople());<BR />&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;for(;users.hasMoreItems():smileywink: <STRONG>//always false ???????</STRONG><BR />&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{<BR />&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;for(PersonInfo personInfo : users.getPage()) {</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<STRONG> //THIS PART OF CODE IS NEVER REACHED</STRONG><BR />&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;String authority = personInfo.getUserName();<BR />&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;logger.info("Analizzo Nodo Utente: " + authority);</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</P><P></P><P>}</P><P></P><P>It's the code right?</P><P>Because it's seem i never reach the code in the inner loop of <STRONG>users.getPage().</STRONG></P><P></P><P><STRONG>UPDATE</STRONG></P><P>Just like Faust said i use the pagingResult in a wrong way. For anyone found it useful here is how resolve the problemastic by using a lucene query:</P><P></P><P>ResultSet rs = null;<BR />&nbsp; <BR />&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; <STRONG>&nbsp;SearchParameters sp = new SearchParameters();</STRONG><BR /><STRONG>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;sp.addLocale(new Locale("it", "IT"));</STRONG><BR /><STRONG>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;sp.addStore(StoreRef.STORE_REF_WORKSPACE_SPACESSTORE);</STRONG><BR /><STRONG>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;sp.setLanguage(SearchService.LANGUAGE_LUCENE);</STRONG><BR /><STRONG>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;sp.setQuery("TYPE:\"cm<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />erson\"");</STRONG><BR /><STRONG>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;sp.setLimitBy(LimitBy.UNLIMITED);</STRONG><BR /><STRONG>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;//little hack to remove the limit from the query</STRONG><BR /><STRONG>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;sp.setMaxItems(-1);</STRONG><BR /><STRONG>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;sp.setMaxPermissionChecks(100000);</STRONG><BR /><STRONG>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;sp.setMaxPermissionCheckTimeMillis(100000);&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;</STRONG><BR /><STRONG>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; sp.addSort(new SortDefinition(SortType.FIELD,ContentModel.PROP_USERNAME.toString(), true));</STRONG><BR /><STRONG>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;rs = searchService.query(sp);&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;</STRONG><BR />&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<BR />&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;long count = rs.getNumberFound();<BR />&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<BR />&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;logger.info("The number of users in the system: " + personService.countPeople());<BR />&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;logger.info("The number of users in the query : " + String.valueOf(count));<BR />&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;for(int i=0;i&lt;rs.length();i++){&nbsp;&nbsp; &nbsp;<BR />&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;ResultSetRow row = rs.getRow(i);<BR />&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;NodeRef personNodeRef = row.getNodeRef();&nbsp;&nbsp; &nbsp;<BR />&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;String authority = (String)nodeService.getProperty(personNodeRef,ContentModel.PROP_USERNAME);</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ...............................................................................</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; logger.info("Username:" + authority);</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</P></BODY></HTML> Fri, 20 Apr 2018 13:41:32 GMT AlfrescoZZZ 2018-04-20T13:41:32Z Get all users of alfresco on java action https://connect.hyland.com/t5/alfresco-forum/get-all-users-of-alfresco-on-java-action/m-p/57577#M20681 Hi, i need to retrieve all the users of alfresco on a java action here the code i use :&nbsp;&nbsp; private NodeService nodeService;&nbsp;&nbsp; &nbsp;private OwnableService ownableService;&nbsp;&nbsp; &nbsp;private PersonService personService;&nbsp;&nbsp; &nbsp;private PermissionService permissionService;&nbsp;&nbsp; &nbsp;private AuthorityService authorityService;@O Fri, 20 Apr 2018 13:41:32 GMT https://connect.hyland.com/t5/alfresco-forum/get-all-users-of-alfresco-on-java-action/m-p/57577#M20681 AlfrescoZZZ 2018-04-20T13:41:32Z Re: Get all users of alfresco on java action https://connect.hyland.com/t5/alfresco-forum/get-all-users-of-alfresco-on-java-action/m-p/57578#M20682 <HTML><HEAD></HEAD><BODY><P>The pattern can be null, but your pattern of "*" is equally valid as both result in a DB SQL '%' (though Alfresco would be more efficient if it did not&nbsp;do the LIKE condition in this case at all).</P><P>Your use of the PagingResult is incorrect (check the JavaDoc!). getPage is always guaranteed to give you the current page of results, while hasMoreItems only specifies that you can get another page in another call with a different PagingRequest. Since you retrieved all people in one request, hasMoreItems will always yield false, causing your code not to be reached.&nbsp;PagingResult are not to be confused with regular Java iterators where your pattern of access would be correct.</P></BODY></HTML> Sat, 21 Apr 2018 10:42:03 GMT https://connect.hyland.com/t5/alfresco-forum/get-all-users-of-alfresco-on-java-action/m-p/57578#M20682 afaust 2018-04-21T10:42:03Z