topic Re: NXQL and ACLs in Nuxeo Forum

NXQL and ACLs

ElmarKnipp_ — Wed, 23 Mar 2022 16:17:41 GMT

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

Re: NXQL and ACLs

LaraGranite_ — Thu, 07 Apr 2022 17:13:15 GMT

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.

Re: NXQL and ACLs

ElmarKnipp_ — Mon, 11 Apr 2022 09:39:17 GMT

Thanks, you are right. The documentation states explicitly