You can easily modify your repeater to only display the documents belonging to a specific Role.
You can easily modify your repeater to only display the documents belonging to a specific Role. To do this, update your query with the following:
Step 1. Using the "CMS_Tree" table, join the field: "NodeALCID" with the "ACLID" field from the "CMS_ACL" table.
Step 2. Join the "CMS_ACL" table with the "CMS_ACLItem" table on the "ACLID" field.
Step 3. Finally join the "CMS_Role" table with the "CMS_ACLItem" table on the "RoleID" field.
With the above steps you can easily apply Role based filtering.