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 ------ .. toctree:: :maxdepth: 1 QueryBuilder_Main Pre-BuiltQueries SavedQuery_Index ToggleLinkTarget QB-Group QBFactsTips Personal -------- .. toctree:: :maxdepth: 1 QB-Age QB-ArchivedFlag QB-GenderId QB-BDate QB-Birthday QB-DaysTillBirthday QB-DaysTillAnniversary QB-MaritalStatusId QB-WeddingDate QB-Grade QB-GradeLevelId QB-FirstName QB-LastName QB-NickName QB-MiddleName QB-MaidenName QB-AltName QB-SchoolOther QB-EmployerOther QB-OccupationOther QB-HasPicture QB-HasMultipleUserAccounts QB-DeceasedDate QB-WidowedDate QB-EmailAddress QB-EmailAddress2 QB-TitleCode QB-RecordType QB-EngagementScoreChange Family ------ .. toctree:: :maxdepth: 1 QB-PositionInFamilyId QB-NumberOfFamilyMembers QB-NumberOfPrimaryAdults QB-HasParents QB-FamilyHasChildren QB-FamilyHasChildrenAged QB-FamilyHasChildrenAged2 QB-FamilyHasChildrenAged3 QB-IsHeadOfHousehold QB-HasRelatedFamily QB-FamHasPrimAdultChurchMemb QB-FamHasStatusFlag QB-FamilyId QB-RelatedFamilyMembers QB-HasFamilyPicture Address ------- .. toctree:: :maxdepth: 1 QB-PrimaryResCode QB-PrimaryZip QB-PrimaryCity QB-PrimaryState QB-PrimaryAddress QB-PrimaryAddress2 QB-PrimaryCountry QB-PrimaryBadAddrFlag QB-HasZipPlus4 QB-GeographicRegion Contact Info ------------ .. toctree:: :maxdepth: 1 QB-HomePhone QB-CellPhone QB-WorkPhone QB-DoNotCallFlag QB-DoNotVisitFlag QB-DoNotMailFlag QB-DoNotPublishPhones QB-HasInvalidEmailAddress QB-EmailAddress QB-EmailAddress2 QB-HeadOrSpouseWithEmail QB-SpouseHasEmail QB-SpouseOrHeadWithEmail QB-SendEmailAddress1 QB-SendEmailAddress2 QB-ReceiveSms Ministry -------- .. toctree:: :maxdepth: 1 QB-FamilyHasContacts QB-HasTaskWithName QB-HasTaskWithNotes QB-HasIncompleteTask QB-DaysSinceContact QB-RecentContactMinistry QB-RecentContactType QB-RecentContactReason QB-EmailRecipient QB-RecentEmailCount QB-RecentEmailSentCount QB-MadeContactTypeAsOf QB-HasContacts QB-ContactRecipient QB-ContactMaker Membership ---------- .. toctree:: :maxdepth: 1 QB-MemberStatusId QB-CampusId QB-DecisionDate QB-DecisionTypeId QB-RecentDecisionType QB-RecentJoinChurch QB-JoinDate QB-JoinDateMonthsAgo QB-JoinCodeId QB-DropDate QB-DropCodeId QB-BaptismDate QB-BaptismTypeId QB-BaptismSchedDate QB-BaptismStatusId QB-NewMemberClassDate QB-NewMemberClassStatusId QB-OtherPreviousChurch QB-OtherNewChurch QB-LetterDateRequested QB-LetterStatusId Enrollments ----------- .. toctree:: :maxdepth: 1 QB-InBFClass QB-IsMemberOf QB-IsInactiveMemberOf QB-IsPendingMemberOf QB-MemberTypeCodes QB-MembOfOrgWithCampus QB-MembOfOrgWithSched QB-RecentRegistrationType QB-SmallGroup QB-NumberOfMemberships QB-HasBalance QB-OrgSearchMember QB-IsProspectOf QB-AttendTypeCodes QB-RecentIncompleteRegistrations QB-IsMemberOfDirectory Enrollment History ------------------ .. toctree:: :maxdepth: 1 QB-WasMemberAsOf QB-MemberTypeAsOf QB-OrgJoinDate QB-OrgJoinDateDaysAgo QB-OrgInactiveDate QB-OrgJoinDateCompare QB-WasRecentMemberOf QB-IsPreviousMemberOf QB-FirstOrgJoinDate QB-OrgMemberJoinedAsOf QB-OrgMemberCreatedDate Current Org ----------- .. toctree:: :maxdepth: 1 QB-HasBalanceInCurrentOrg QB-InCurrentOrg QB-InactiveCurrentOrg QB-PendingCurrentOrg QB-PreviousCurrentOrg QB-ProspectCurrentOrg QB-VisitedCurrentOrg QB-LeadersUnderCurrentOrg QB-MembersUnderCurrentOrg Volunteer --------- .. toctree:: :maxdepth: 1 QB-HaveVolunteerApplications QB-VolunteerApprovalCode QB-VolAppStatusCode QB-VolunteerProcessedDateMonthsAgo QB-PmmBackgroundCheckStatus QB-MVRProcessedDateMonthsAgo QB-MVRStatusCode QB-DaysSinceLastCheck QB-CheckDateRange QB-DaysSinceLastTraining QB-TrainingDateRange QB-TrainingProcessedMonthsAgo QB-MonthsSinceLastBackgroundCheck QB-TrainingStatusCode Recent Attendance ----------------- .. toctree:: :maxdepth: 1 QB-RecentAttendMemberType QB-VisitNumber QB-RecentVisitNumber QB-RecentVisitNumberOrgs QB-RecentAttendType QB-AttendPct QB-RecentAttendCount QB-RecentAttendCountAttCred QB-KidsRecentAttendCount QB-NeedAttendance QB-HasRecentNewAttend QB-RecentFirstFamilyVisit QB-RecentFamilyAdultLastAttend Attendance Dates ---------------- .. toctree:: :maxdepth: 1 QB-AttendedAsOf QB-AttendMemberTypeAsOf QB-AttendTypeAsOf QB-AttendPctHistory QB-AttendCntHistory QB-DaysBetween12Attendance QB-DaysAfterNthVisitDateRange QB-GuestAsOf QB-CheckInByDate QB-CheckInByActivity QB-MeetingId QB-RegisteredForMeetingId QB-CommitmentForMeetingId QB-HasCommitmentForMeetingId QB-FirstFamilyVisitAsOf QB-GetEldestFamilyMember Contributions ------------- .. toctree:: :maxdepth: 1 QB-EnvelopeOptionsId QB-ContributionOptionsId QB-RecentContributionCount QB-RecentContributionAmount QB-RecentContributionAmountBothJoint QB-ContributionAmountBothJointHistory QB-IsRecentGiver QB-IsRecentGiverFunds QB-RecentHasFailedRecurringGiving QB-RecentManagedGiving QB-RecentNonTaxDedCount QB-RecentNonTaxDedAmount QB-NonTaxDedAmountBothJoint QB-NonTaxDedAmountDonorOnly QB-RecentPledgeCount QB-RecentPledgeAmount QB-RecentPledgeAmountBothJoint QB-PledgeAmountBothJointHistory QB-PledgeBalance QB-ContributionAmount2 QB-ContributionAmount2DonorOnly QB-ContributionChange QB-GivingChange QB-RecentHasIndContributions QB-RecentFirstTimeGiver QB-RecentFirstTimeGiverByDate QB-IsTopGiver QB-IsTopPledger QB-IsFamilyGiver QB-IsFamilyGiverFunds QB-IsFamilyPledger QB-HasManagedGiving QB-ManagedGivingCreditCard QB-CcExpiration QB-WantsElectronicStatement QB-RecentBundleType QB-HadIndContributions Extra Values ------------ .. toctree:: :maxdepth: 1 QB-PeopleExtra QB-PeopleExtraData QB-PeopleExtraDate QB-PeopleExtraInt QB-HasPeopleExtraField QB-FamilyExtra QB-FamilyExtraData QB-FamilyExtraDate QB-FamilyExtraInt QB-HasFamilyExtraField QB-RecentPeopleExtraFieldChanged QB-DaysSinceExtraDate Miscellaneous ------------- .. toctree:: :maxdepth: 1 QB-IncludeArchived QB-IncludeDeceased QB-ParentsOf QB-StatusFlag QB-RecentFlagAdded QB-HasCurrentTag QB-HasMyTag QB-HasMemberDocs QB-HasFinanceDocs QB-EntryPointId QB-OriginId QB-InSqlList QB-InterestPointId QB-MemberAnyChurch QB-NotChurchMember QB-PlusParentsOf QB-PlusSpouseOf QB-SavedQuery QB-RecActiveOtherChurch QB-RecInterestedCoaching QB-InOneOfMyOrgs QB-CheckInVisits QB-MedicalLength QB-HasFailedEmails QB-FirstPersonSameEmail QB-DaysSinceDateField QB-EngagementScoreChange Admin ----- .. toctree:: :maxdepth: 1 QB-UserRole QB-IsUser QB-CreatedBy QB-CreatedDate QB-RecentCreated QB-RecentChanged QB-IsCurrentPerson QB-IsCurrentUser QB-DuplicateEmails QB-DuplicateNames QB-HasLowerName QB-PeopleIds QB-HasOptoutsForEmail QB-PeopleId QB-HasOpenedEmail QB-HasSpamBlock QB-MatchAnything QB-MatchNothing +--------------------+------------------+ | **Latest Update** | **08/30/2022** | +--------------------+------------------+ Added new volunteer management conditions.