topic Fastest way to retrieve all content for a user? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/fastest-way-to-retrieve-all-content-for-a-user/m-p/144770#M101221 <HTML><HEAD></HEAD><BODY><SPAN>Hello!</SPAN><BR /><BR /><SPAN>I'm trying to develop a WebScript to retrieve all content from the repository (from app:company_home//*) where an user has access (i.e. </SPAN><STRONG>Consumer</STRONG><SPAN> permission) and doing it the fastest way possible.</SPAN><BR /><BR /><SPAN>I've tried several approachs, the fastest being:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>Set&lt;NodeRef&gt; nodes = permissionService<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.findNodesByAssignedPermissionForCurrentUser(<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PermissionService.CONSUMER, true, true, true);<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>and then walking the tree recursively from these nodes checking permission access without repeating searchs (i.e. one of the nodes in the set containing another as descendant).</SPAN><BR /><BR /><SPAN>This approach is slightly faster than walking the whole app:company_home tree.</SPAN><BR /><BR /><SPAN>The problem is that its performance depends mostly in the "inherit permissions" property of a node and in the state of the permission cache.</SPAN><BR /><BR /><SPAN>I also tried with Lucene, but Lucene Search doesn't seem to support user-permission metadata, does it?</SPAN><BR /><BR /><SPAN>Any ideas or suggestions would highly appreciated!</SPAN><BR /><BR /><SPAN>Thanks!</SPAN></BODY></HTML> Fri, 23 Nov 2007 12:09:57 GMT albertomv 2007-11-23T12:09:57Z Fastest way to retrieve all content for a user? https://connect.hyland.com/t5/alfresco-archive/fastest-way-to-retrieve-all-content-for-a-user/m-p/144770#M101221 Hello!I'm trying to develop a WebScript to retrieve all content from the repository (from app:company_home//*) where an user has access (i.e. Consumer permission) and doing it the fastest way possible.I've tried several approachs, the fastest being<IMG id="smileyfrustrated" class="emoticon emoticon-smileyfrustrated" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-frustrated.png" alt="Smiley Frustrated" title="Smiley Frustrated" />et&lt;NodeRef&gt; nodes = permissionService&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Fri, 23 Nov 2007 12:09:57 GMT https://connect.hyland.com/t5/alfresco-archive/fastest-way-to-retrieve-all-content-for-a-user/m-p/144770#M101221 albertomv 2007-11-23T12:09:57Z Re: Fastest way to retrieve all content for a user? https://connect.hyland.com/t5/alfresco-archive/fastest-way-to-retrieve-all-content-for-a-user/m-p/144771#M101222 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>There is no easy way to do what you want.</SPAN><BR /><BR /><SPAN>2.2 will have a new permission model which will make this query possible, althought the support you want is likely not to be implemented in the first cut. I will take another look.</SPAN><BR /><BR /><SPAN>Andy</SPAN></BODY></HTML> Mon, 03 Dec 2007 11:35:22 GMT https://connect.hyland.com/t5/alfresco-archive/fastest-way-to-retrieve-all-content-for-a-user/m-p/144771#M101222 andy 2007-12-03T11:35:22Z