Org Search Member Stats¶
This script runs from the OrgSearch BlueToolbar.
The intent of the report is to allow you to filter for a set of organizations and get a report of all current members in those orgs along with the following information related to that org and information related to the individual’s Main Fellowship org:
Org ID# (which is a link to the org)
First Name of individual
Last Name of individual
Join Date (church membership)
Enroll Date (org enrollment)
Last Attended Date
Member Type (in filtered Org)
Main Fellowship Org Name
Main Fellowship Leader
Main Fellowship Date Last Attended
Main Fellowship Attendance Percentate
Main Fellowship Attendance String
The reason we added the Main Fellowship information is to allow you to further evaluate a person’s involvement in your church.
Use the following code to Create the SQL Script. See How to create a SQL Script.
;With FellowshipInfo as ( SELECT c.OrganizationId ,c.OrganizationName , c.FirstName , c.LastName , c.PeopleId , c.JoinDate , c.EnrollDate , c.LastAttend , c.AttendPct , c.AttendStr , c.MemberType , p.BibleFellowshipClassId FROM dbo.CurrOrgMembers(@orgids) c JOIN People p on p.PeopleId = c.PeopleId ) Select fi.OrganizationId , fi.OrganizationName , fi.FirstName , fi.LastName , fi.JoinDate , fi.EnrollDate , fi.LastAttend , fi.AttendPct , fi.AttendStr , fi.MemberType , MainFellowshipName = mf.OrganizationName , MFLeader = mf.LeaderName , MFLastAttend = mfm.LastAttended , MFAttPct = mfm.AttendPct , MFAttStr = mfm.AttendStr FROM FellowshipInfo fi JOIN Organizations mf on fi.BibleFellowshipClassId = mf.OrganizationId JOIN OrganizationMembers mfm on mfm.PeopleId = fi.PeopleId and mfm.OrganizationId = fi.BibleFellowshipClassId ORDER BY fi.OrganizationID, fi.LastName
Modify image link with secure protocol.