Note: As of July 9, 2018, Blackbaud’s School Management solutions (which include Core, onBoard, onCampus, onMessage, and onRecord) are utilizing a new top level navigation. This primarily affects users performing administrative tasks—constituent navigation for most parents, students, faculty, and alumni will remain the same. We appreciate your patience as we work to update our documentation. If you are seeing this message, the content of this solution is still being vetted for possible updates. Please refer to this mapping document if you need assistance finding a task in the new navigation.
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