Search Builder¶
The articles in the Basics section are all about how Search Builder works, about built-in searches in TouchPoint, and other general facts about Search Builder.
The articles below the Basics section are grouped by category as they are inside Search Builder. There is one article for each individual Condition in Search Builder.
Basics¶
Personal¶
- Age
- Archived Flag
- Gender
- Birthdate
- Birthday
- Days Till Birthday
- Days Till Anniversary
- Marital Status
- Wedding Date
- Grade (Legacy)
- Grade
- First Name
- Last Name
- Nick Name
- Middle Name
- Maiden Name
- AltName
- School
- Employer
- Occupation
- Has Picture
- Has Multiple User Accounts
- Deceased Date
- Widowed Date
- Email2
- SMS Group Subscribed
- SMS Group Opt Out
- Title
- People Record Type
- Engagement Score
Family¶
- Position in Family
- Number of Family Members
- Number of Primary Adults
- Has Parents
- Family Has Children
- Family Has Children Aged
- Family Has Children Aged Range
- Family Has M/F Children Aged Range
- Is Head of Household
- Has Related Family
- Family Has Primary Adult Church Member
- Family Member Has Status Flag
- Family
- Related Family Members
- Has Family Picture
Address¶
Contact Info¶
Ministry¶
- Family Has Notes
- Task Assigned With Details
- Task Assigned With Keywords
- Task About With Details
- Task About With Keywords
- Has Incomplete Task
- Days Since Last Note
- Recent Note With Keywords
- Recent Contact Type
- Recent Contact Reason
- Email Recipients
- Recent Email Count
- Recent Email Sent Count
- Made Note With Keywords As Of
- Has Notes
- Contact Recipients
- Contact Makers
Membership¶
- Church Member Status
- Campus
- Decision Date
- Decision Type
- Recent Decision Type
- Recent Join Church
- Recent Join Church Days Range
- Join Date
- Join Date Months Ago
- Join Type
- Drop Date
- Drop Type
- Baptism Date
- Baptism Type
- Baptism Scheduled Date
- Baptism Status
- New Member Class Date
- New Member Class Status
- Former Church
- New Church
- Letter Requested Date
- Letter Status
Enrollments¶
- In Main Fellowship
- Is Member Of
- Is Inactive Member Of
- Is Pending Member Of
- Member Type Codes
- Involvement Member with Campus
- Involvement Member With Schedule
- Recent Registration Type
- In Sub-Group
- Number of Enrollments
- Has Balance In Involvement
- Involvement Search Member
- Is Prospect Of
- Attend Type Codes
- Recent Incomplete Registrations
- Is Member of Directory
Enrollment History¶
Current Involvement¶
Volunteer¶
- Has Volunteer Applications
- Volunteer Approval Code
- Volunteer App Status Code
- Volunteer Class Status Code
- Volunteer Processed Months Ago
- Volunteer Class Taken Months Ago
- Background Check Status Code
- MVR Processed months ago
- MVR Status Code
- Check Date Range
- Days Since Last Background Check
- Days Since Last Training
- Training Date Range
- Training Processed Months Ago
- Months Since Last Background Check
- Training Status Code
Recent Attendance¶
- Recent Attended Member Type
- Visit Date Nth Time
- Recent Visit date Nth time
- Recent Visit date Nth time for Involvements
- Recent Attendance Type
- Attendance %
- Recent Attendance Count
- Recent Attendance Count for Schedule/AttendCredit
- Kids Recent Attendance Count
- Need Attendance
- Has Recent New Attend
- Recent First Family Visit
- Recent Family Attend by Primary Adult
Attendance Dates¶
- Attended As Of
- Member Type Attended as Of
- Attendance Type as Of
- Attendance % History
- Attendance Count History
- Days Between First/Second Attend
- Attend Days After Nth Visit
- Guest As Of
- Building Check-In Count History
- Building Check-In by Activity
- Meeting ID
- Registered for Meeting ID
- Commitment for Meeting Id
- Has Commitment for Meeting Id
- First Family Visit
- Eldest Family Member That Attended
Contributions¶
- Envelope Options
- Contribution Options
- Recent Contribution Count
- Recent Contribution Amount
- Recent Contribution Amount With Both Joint
- Contribution Amount With Both Joint by Date Range
- Contribution Amount With Both Joint Since Setting
- Recent Giver
- Recent Giver to Funds
- Recent Has Failed Recurring Giving
- Recent Managed Giving
- Recent NonTaxDed Count
- Recent NonTaxDed Amount
- NonTaxDed Contribution Amount History Both Joint
- NonTaxDed Contribution Amount History Donor Only
- Recent Pledge Count
- Recent Pledge Amount
- Recent Pledge Amount With Both Joint
- Pledge Amount With Both Joint by Date Range
- Pledge Balance
- Contribution Amount History Both Joint
- Contribution Amount History Donor Only
- Contribution Change Pct
- Giving Change
- Recent Has Individual Contributions
- Recent First Time Giver
- First Time Giver
- Recent Top Giver
- Recent Top Pledger
- Is in a Giving Family
- Is in a Giving Family toward FundSet
- Is in a Pledging Family
- Has Managed Giving
- Has Managed Pledges
- First Recurring Gift
- Managed Giving With Credit Card
- Credit Card Expire Days
- Wants Electronic Statement Only
- Recent Contributions In BundleType
- Had Individual Contributions
- Soft Credit Recipient Number of Days
- Soft Credit Recipient Date Range
Extra Values¶
Miscellaneous¶
- Include Archived
- Include Deceased
- Parents Only
- Status Flag
- Recent Flag Added
- Active Tag
- Tagged with
- Has Membership Documents
- Has Finance Documents
- Entry Point
- Record Origin
- In SQL List
- Interest Point
- Member of Any Church
- Not a Church Member
- Add Primary Adults
- Add Spouse
- Saved Searches
- Reg Other Church
- Reg Interested Coaching
- In One of My Involvements
- In One of My Main Fellowship Involvements
- Number of visits
- Length of Medical / Allergies Info
- Has Failed Emails
- First Person of Same Email
- Days Since Date Field
- Days Since Date
- Is Business
- Is An Active Record
- Query Tag
Admin¶
- User in Role
- Recent Login Days Ago
- Number of recent web browser logins
- Failed Email Send
- Is System User
- Record Created By User
- Record Created On Date
- Recent Created Record
- Recent Changed Record
- Recent Mobile App Use
- Is Current Person
- Is Current User
- Duplicate Emails
- Duplicate Names
- Has Lowercase Name
- Has One Of PeopleIds
- Has Email Optouts for address
- People ID
- Opened Email
- Has Spam Block
- Select Condition
- Match Nothing
Latest Update |
10/20/2026 |
Removed defunct InCurrentOrg condition and 3 unused legacy task conditions, renamed 8 doc files to match current code condition names, added 4 orphaned docs to index, and created 12 new articles for previously undocumented conditions. Renamed the Current Org heading to Current Involvement. Added 5 articles that were missing from the index: SMS Group Subscribed, SMS Group Opt Out, In One of My Main Fellowship Involvements, Is An Active Record, and Number of recent web browser logins.