NXQL and ACLs
I want to find all folders where special ACLs (Access Control Lists) are used. As a simple example, where a Read access is granted. Whenever I add such a condition (line 1 in my example below), nothing is found. Without the condition, the expected results are retrieved.
Here is my query:
SELECT * FROM Document WHERE ecm:acl/*/permission = 'Read' AND ecm:isTrashed = 0 AND ecm:primaryType = 'Folder'
Any hints? - Thanks
That query looks correct. It only returns local permissions, so if you have inherited Read permissions on a folder, it won't show up in the results.
Nevertheless, if I set a local Read permission on the document and query the repo as described in my original post, nothing is found.
BTW: Is there a possibility to query for inherited ACEs?