Below are some additional examples of Select statements from the Profile Editor, used to view personnel records across multiple Controller Groups:
Example 1: (Admin)
personnel_rec.region in (0,1,2,3)
Example 2: (Tenant A)
personnel_rec.region in (0,2)
Example 3: (Tenant B)
personnel_rec.region in (0,3)
The examples above assume Controller Group 1 to be the common readers and Region 2 is for Tenant A only and Controller Group 3 is for Tenant B only. It’s important to include the 0 in the list of regions so that Personnel records that do not have an access level assigned will show up in the list.