topic Re: Query folders granted to person in Alfresco Forum

Query folders granted to person

skushnerenko — Mon, 02 Apr 2018 08:17:43 GMT

I need to query a full list of folders in folder tree inside a repository, granted to certain person directly (not through inheritence or group membership).Or at least a list of files inside such folders.The purpose is to give access for one person to all folders in repository accessible to another

Re: Query folders granted to person

afaust — Mon, 02 Apr 2018 19:01:38 GMT

There is no functionality in Alfresco to query folders by directly assigned permissions. Technically, since SOLR indexes ACLs, you could query using the READER meta field which will be only set to the user name of a specific user if that user has an explicit permission on the node or via inheritance (you'd need to filter out the inheritance after the query). But be aware that you will only get a result based on the eventually consistent index and some structures may not be indexed (i.e. via cm:indexControl).

Re: Query folders granted to person

skushnerenko — Tue, 03 Apr 2018 08:52:32 GMT

It should have solved my task, but I am not sure with query syntax.

I have tried all possible variants, for example

PATH:"/app:company_home/cmED_ROOT//*" AND TYPE:"cm:folder" AND -TYPE:"cm:systemfolder" AND @cm\:READER:"DEMO"

Re: Query folders granted to person

afaust — Wed, 04 Apr 2018 09:30:10 GMT

READER is a meta-field and not associated with any namespace. The query should be something like

PATH:"/app:company_home/cm:SED_ROOT//*" AND TYPE:"cm:folder" AND -TYPE:"cm:systemfolder" AND READER:"<userName>"‍

Also note: The @ in FTS queries is absolutely unnecessary - it is only a legacy remnant of the Lucene query syntax.