How can I create a List of a User who is one Role but not also another role?
For example, if you want to create an Advanced List that includes a user who is a Parent but is also NOT a Teacher (can be used for all roles by updating the filters):
1. Add the Constituent information Objects: User Base, User Role (unless these already exist in your current list) and another User Role 2. User Role object should be a Inner Join (check box should be checked beside the word Inner) 3. User Role  object should not be an Inner Join (check box should not be checked beside the word Inner)
4. Add the Global Filters User Role.Role Any of ROLE you want the user to be (in the above example this would be Parent) and User Role .User ID is NULL 5. Object Filter User Role .Role is/Contains/Any of ROLE you do not want the user to be. (in the above example this would be Teacher) How this will look in the Filters List using the example:
Global Filters: User Role.Role Any of: Parent User Role .User ID is NULL Object Filters: User Role .Role is/Contains/Any of: Teacher