SQL – Personnel Records Across Multiple Controller Groups

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.