NXQL and ACLs

[ElmarKnipp_]

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

[LaraGranite_]

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.

[ElmarKnipp_]

Thanks, you are right. The documentation states explicitly