9 YEARS AGO

Role based ##WHERE## condition

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.