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