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.
I read https://doc.nuxeo.com/nxdoc/nxql/ and also https://jira.nuxeo.com/browse/NXP-15970 so I think I have understood the concept for pseudo-list.
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?