This Condition located on the Personal category tab in Search Builder will present a drop down list of Schools that are on people records. This list is created automatically whenever a school is entered on a person’s record.
When adding a School (or Employer) to a record, start typing and a list will begin to display after you type 3 letters. Always look for the School in the list first before adding a new one.
You want to find everyone who has a School on their record, but is NOT attending Briarcrest or ECS.
- Condition = School
- Comparison = Not One Of and select Briarcrest and ECS
- Results will be everyone that has a School on their record that is NOT one of those 2 Schools
This search will not include anyone without a School on their record.