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.

Use Case

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.