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 until Birthday
- Days Until Anniversary
- Marital Status
- Wedding Date
- Grade - Legacy
- Grade
- First Name
- Last Name
- Nick Name
- Middle Name
- Maiden Name
- Alt Name
- School
- Employer
- Occupation
- Has Picture
- Has Multiple User Accounts
- Deceased Date
- Widowed Date
- Email Address - Primary
- Email Address - Secondary
- 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 Age X and Under
- 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 ID
- Related Family Members
- Has Family Picture
Address¶
Contact Info¶
Ministry¶
- Family Has Notes
- 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 Recipient
- Recent Email Count
- Recent Email Sent Count
- Made Note With Keywords As Of
- Has Notes
- Contact Recipients
- Contact Makers
Membership¶
- Member Status
- Campus ID
- Decision Date
- Decision Type
- Recent Decision Type
- Recent Join Church
- 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
- Previous (Former) Church
- New Church
- Letter Requested Date
- Letter Status
Enrollments¶
- In Main Fellowship Class
- Is Member Of
- Is Inactive Member Of
- Is Pending Member Of
- Member Type Codes
- Member of Org with Campus
- Member of Org with Schedule
- Recent Registration Type
- In Sub-Group
- Number of Enrollments
- Has Balance in Organization
- Org Search Member
- Is Prospect Of
- Attend Type Codes
- Recent Incomplete Registrations
- Is Member of Directory
Enrollment History¶
Current Org¶
Volunteer¶
- Has Volunteer Applications
- Volunteer Approval Code
- Volunteer Application Status Code
- Volunteer Processed Months Ago
- Background Check Status Code
- MVR Processed Date Months Ago
- MVR Status Code
- Check Date Range
- Days Since Last Training
- Training Date Range
- Training Months Ago
- Months Since Last Background Check
- Training Status Code
Recent Attendance¶
- Recent Attend Member Type
- Visit Date Nth Time
- Recent Visit Number
- Recent Visit Number Orgs
- Recent Attend Type
- Attendance Percent
- Recent Attend Count
- Recent Attendance Count by Attendance Credit
- Kids Recent Attendance Count
- Need Attendance
- Has Recent New Attend
- Recent First Family Visit
- Recent Family Adult Last Attended
Attendance Dates¶
- Attended As Of
- Member Type Attended as Of
- Attendance Type as Of
- Attendance Percent History
- Attendance Count History
- Days Between 1st and 2nd Attendance
- Days After Nth Visit with Date Range
- Guest As Of
- Building Check-In by Date
- Building Check-In by Activity
- Meeting ID
- Registered for Meeting ID
- Commitment for Meeting Id
- Has Commitment for Meeting Id
- First Family Visit As Of
- Get Eldest Family Member that Attended
Contributions¶
- Envelope Options
- Contribution Options
- Recent Contribution Count
- Recent Contribution Amount
- Recent Contribution Amount Both Joint
- Contribution Amount (with Both Joint) by Date Range
- Recent Giver
- Recent Giver to Funds
- Recent Has Failed Recurring Giving
- Recent Managed Giving
- Recent Non-Tax Deductible Count
- Recent Non-Tax-Deductible Amount
- Non-Tax-Deductible Amount Both Joint
- Non-Tax-Deductible Amount Donor Only
- Recent Pledge Count
- Recent Pledge Amount
- Recent Pledge Amount with Both Joint
- Pledge Amount History with Both Joint
- Pledge Balance
- Contribution Amount History
- Contribution Amount History Donor Only
- Contribution Change Percent
- Giving Change
- Recent Individual Contributions
- Recent First Time Giver
- First Time Giver
- Is Top Giver
- Is Top Pledger
- Is in Giving Family
- Is in a Giving Family toward FundSet
- Is in a Pledging Family
- Has Managed Giving
- Managed Giving with Credit Card
- Credit Card Expiration
- Wants Electronic Statement
- Recent Contribution in Bundle Type
- Had Individual Contributions
Extra Values¶
- Extra Value Code
- Extra Value Text
- People Extra Value Date
- People Extra Value Integer
- People Extra Value Field
- Family Extra Value Code
- Family Extra Value - Text
- Family Extra Value - Date
- Family Extra Value - Integer
- Has Family Extra Value - Field
- Recent People Extra Field Changed
- Days Since Extra Value Date was Set
Miscellaneous¶
- Include Archived
- Include Deceased
- Parents Only
- Status Flag
- Recent Flag Added
- Has Current Tag
- Has My Tag
- Has Membership Documents
- Has Finance Documents
- Entry Point
- Origin
- In SQL List
- Interest Point
- Member Any Church
- Registration - Not Church Member
- Add Primary Adults
- Add Spouse
- Saved Search
- Registration - Active in Other Church
- Registration, Interested in Coaching
- In One of My Involvements
- Number of Check-In Visits
- Medical Length
- Has Failed Emails
- First Person Same Email
- Days Since Date Field
- Engagement Score