Open Source Church/Data and Reports

From the top menu, selecting Data/Report --> Query Menu, you can run the following Queries:

Advanced Search: Search anywhere in the Name, City, State, Zip, Home Phone, Email, or Work Email string.

Birthdays: Birthdays of Persons in a given month

CustomSearch: Find people with a custom field value

Households to be surveyed: People in households that are good for taking surveys.

Count of family members: Returns each household and the total number of people assigned to it.

Family Pledge by Fiscal Year: Commitment summary by family name for each fund for the selected fiscal year

Membership anniversaries: Members who joined in a particular month

Missing people: Find people who didn't attend an event

Missing tasks: Find people who have pledged a commitment in one year but not another

People by age: Returns any person record with ages between two dates.

Persons per property: Returns records of people who have been given the specified property.

People by role and gender: Select the records of people with the specified family role and gender.

Commitment Comparison: Compare commitments between two fiscal years

Recent friends: Friends who signed up in the previous months

Registered students: Find registered students

Select all members: People who are members

Select database users: Persons registered as database users

Total by gender: Total records matching a given gender.

Volunteers: Find volunteers for a particular opportunity

Volunteers: Find volunteers who match two specific opportunity codes