nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Node with certain permissions

luca

Is there a way to retrieve nodes with or without a certain permission inside a folder with a query?

Find more posts tagged with

Comments

vinhqchu

u can use the AuthenticationUtil.runAs to query as admin. this will give u all the results whether the actual user has permission or not.

luca

Thank You,
but I resolved using a query like this:

SELECT n.id, n.uuid, n.acl_id, q2.local_name as type,
       (SELECT np.string_value
          FROM alf_node_properties np, alf_qname q1
         WHERE np.node_id = n.id  AND  q1.id = qname_id  AND  q1.local_name = 'name') as NAME
  FROM alf_node n, alf_qname q2
 WHERE q2.id = n.type_qname_id
   AND q2.local_name in ('folder', 'content')
   AND n.acl_id not in (
SELECT acl.id
  FROM alf_acl_member m, 
       (SELECT ac.id, p.name, au.authority
          FROM alf_access_control_entry ac, alf_permission p, alf_authority au
         WHERE p.id = permission_id
           AND au.id = authority_id) ace,
       alf_access_control_list acl
 WHERE ace.id = m.ace_id
   AND acl.id = m.acl_id
   AND ace.authority = 'GROUP_NAME'
   )‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍