topic SQL to filter by allowable actions in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/sql-to-filter-by-allowable-actions/m-p/278215#M231345 <HTML><HEAD></HEAD><BODY><SPAN>I am helping build Alfresco client support (via CMIS) into an existing Java application. In our Alfresco implementation we have a number of different sites - currently almost 100. At full implementation we may have considerably more. Our targeted user community will be segregated by project and a typical user will only have write access to a limited number of sites.</SPAN><BR /><BR /><SPAN>I want to retrieve a sorted list of sites that includes only the sites to which a user has write access (allowable actions CAN_CREATE_DOCUMENT,CAN_UPDATE_PROPERTIES, etc.). I have this currently working very nicely with the API via getDescendents on the Sites folder and related method calls.</SPAN><BR /><BR /><SPAN>The problem: performance sucks (is terrible, for those not familiar with English slang). It can take up to 30 seconds to return the filtered, sorted list of sites to the user. This will only get worse as we add more sites.</SPAN><BR /><BR /><SPAN>I have coded an alternate implementation that fetches only the relevant properties for the user UI using an SQL query. It returns a sorted list in 2 seconds. The only problem is that this list is not filtered by allowable actions.</SPAN><BR /><BR /><SPAN>Is there a way to query allowable actions using SQL?</SPAN><BR /><BR /><SPAN>I am happy to post code fragments on request, but this seems like a generic type of question so I won't for now.</SPAN><BR /><BR /><SPAN>Thanks,</SPAN></BODY></HTML> Wed, 18 Jun 2014 21:02:05 GMT mikerawlins 2014-06-18T21:02:05Z SQL to filter by allowable actions https://connect.hyland.com/t5/alfresco-archive/sql-to-filter-by-allowable-actions/m-p/278215#M231345 I am helping build Alfresco client support (via CMIS) into an existing Java application. In our Alfresco implementation we have a number of different sites - currently almost 100. At full implementation we may have considerably more. Our targeted user community will be segregated by project and a ty Wed, 18 Jun 2014 21:02:05 GMT https://connect.hyland.com/t5/alfresco-archive/sql-to-filter-by-allowable-actions/m-p/278215#M231345 mikerawlins 2014-06-18T21:02:05Z Re: SQL to filter by allowable actions https://connect.hyland.com/t5/alfresco-archive/sql-to-filter-by-allowable-actions/m-p/278216#M231346 <HTML><HEAD></HEAD><BODY><SPAN>I assume that you know you can retrieve the allowable actions with the objects by passing includeAllowableActions=true as part of the request. You'll still have to filter the result set based on those values, though, because the spec doesn't provide for a query filter based on that.</SPAN><BR /><BR /><SPAN>Jeff</SPAN></BODY></HTML> Mon, 07 Jul 2014 19:49:19 GMT https://connect.hyland.com/t5/alfresco-archive/sql-to-filter-by-allowable-actions/m-p/278216#M231346 jpotts 2014-07-07T19:49:19Z