How to Use Search Builder

Search Builder finds the people in your database who meet the Conditions you specify. Use it to build a list to email, print labels for, or run reports on, or to count how many people match your criteria.

For an introduction, watch the Search Builder Basics training video.

A search can use a single Condition, such as everyone with a Church Member Status of Member, or combine several Conditions. For example:

  • Members aged 30-40 with children in a specified age range who attended something within a specified number of days.

  • Everyone who attended a Worship Service as a New Guest during a specified date range and has not attended a Life Group.

Note

Databases created after May 16, 2017, include five sample searches. To find them, go to People > Search Builder > Saved and enter sample in the name field.

Results, Reports, Actions

The results page always shows the same columns, regardless of the Conditions in the search. Use the Blue Toolbar to run reports or take action on the people in the results.

See also

Toolbar Options

Groups

Each search contains at least one Group, and you can add more. A Group is a set of Conditions joined by the Match option at its top: All, Any, None, or Not All. Click + Group to add a Group inside the current one, so one search can combine different match types. For example, a top Group set to Match All can require Member status, while a Group inside it set to Match Any finds people enrolled in either of two Involvements. The cog menu on a Group includes Copy, Paste, Insert Group Above This, and Delete.

View Code

View Code, below the Conditions in an open search, shows the code Search Builder uses to run the search. In the code, OR joins Conditions under Match Any, and AND joins Conditions under Match All.

Use it to:

  1. Review the entire search without opening each Condition.

  2. Copy the search into a Python script, so the script does not need to reference a saved search.

https://i.tpsdb.com/hayley-SBViewCode.png

Individual Search

https://i.tpsdb.com/hayley-SBViewCode2.png

Code for Individual Search

Status Flags

Search Builder is also used to create Status Flags. The Search Builder Deep Dive training video covers Status Flags, building searches, and troubleshooting.

Condition Categories

Conditions are grouped into 17 categories. The Conditions dialog opens on the All tab, where you can filter by keyword, or you can select a category from Categories.

Tip

Click the ?Help Article button beside a Condition to open its help article.

Personal

Age, gender, marital status, employer, occupation, and other Conditions about an individual

Family

Position in family, number of family members, children in the family, and other family Conditions

Address

Resident code, ZIP code, city, and other address Conditions

Contact Info

Phone numbers, email addresses, texting, and other contact Conditions

Task And Notes

Notes and Tasks, including Keywords, who a Task is assigned to, and who a Task or Note is about

Membership

Campus, member status, join date, decision type, and other church membership Conditions

Ministry

Contacts, emails sent and received, and Tasks

Enrollments

Current enrollments, including member type, sub-group, and number of enrollments

Enrollment History

Enrollment dates and past enrollments

Current Involvement

People related to the Involvement you viewed most recently, such as members, prospects, and previous members

Volunteer

Volunteer status, volunteer applications, approval codes, and other items on a person’s Volunteer tab

Recent Attendance

Attendance within a number of days, including children’s attendance

Attendance Dates

Attendance within a date range

Extra Values

Person and family Extra Values

Contributions

Envelope options, statement options, giving history, and other contribution Conditions. For an overview, watch the Search Builder Conditions (Contributions) training video.

Important

You must have the Finance role to get results from these Conditions. Without it, the search returns 0 people and does not show an error.

Miscellaneous

Conditions that do not fit in the other categories

Admin

User accounts, record creation dates and creators, and other system Conditions

Note

Search Builder Restrictions: when the RestrictSearchBuilder setting is turned on, users without the Admin role don’t see these category tabs: Membership, Ministry, Enrollments, Enrollment History, Current Involvement, Volunteer, Recent Attendance, Attendance Dates, and Task And Notes.



Latest Update

10/19/2026

Rewrote the article in a concise, professional style, replaced the YouTube videos with the current training videos, updated the New Search menu path, and added the Task And Notes and Search Builder Restrictions information. Expanded the Groups section.