Basic Query

To query you’ll need to fill in the following information:

1. The table you’ll be querying from. For example, if the criteria is the City, you’ll be querying from the Address table. Enter this in the Query In portion of the query editor.
2. The field name. In that same example, if the criteria is City, you’ll need to select City from the Field Name drop down box.
3. The comparison. In this example the comparison would be “is equal to”. Highlight that in the Comparison box.
4. The value. Enter the name of the city you are interested in, in the Value field.
5. Press the QUERY button. A list of all the people who live in that city will be returned.

Multiple criteria query

Let’s say you want to know all the females from the city of Chicago. We’ll have two lines in this query.

1. Under the People menu, click on Search Profiles. Click SEARCH icon.

2. Enter Address as the Query In table.

3. Select “City” from the Field Name drop down box.

4. Highlight “is equal to” in the Comparison box.

5. Select "Chicago” as the Value.

6. Press the ADD LINE button.

7. Select People from the Query In table.

8. Select “Gender” from the Field Name drop down box.

9. Highlight “is equal to” from the Comparison box.

10. Enter Female as the Value.

11. Press QUERY. A list of women from Chicago will be displayed.

Associations query

Let’s say you want to know all the people that are Members or Regular Attenders. In this example, we’ll need to use the Associations tab of the query editor.

1. Under the People menu, click on Search Profiles. Click SEARCH icon.
2. Click on the Associations tab.

3. Click on each Association you want to include in the query.
4. Press QUERY to execute the query.

An either/or criteria

In this example, let’s say we need a list of all the people who live in a certain city OR they are assigned to a specific shepherd area.

1. Under the People menu, click on Search Profiles. Click SEARCH icon.
2. Enter “Address” as the Query In table. (both city and shepherd area are stored in the address table)
3. Select “City” from the Field Name drop down box.
4. Highlight “is equal to” in the Comparison box.
5. Enter “El Paso” as the Value.
6. Press the ADD LINE button.

7. Press the OR button. Notice the AND is changed to OR on the second line.
8. Select “Shepherd Area” from the Field Name drop down box.
9. Highlight “is equal to” from the Comparison box.
10. Select “Aram’s” as the Value.
11. Press QUERY. A list of people who live in Evergreen OR are in Aram’s shepherd area is displayed.

Date Range Criteria

For this example, let’s create a query that gives us a list of people who have given a donation between January 1, 2017 and July 31, 2017.

1. Under the People menu, click on Search Profiles. Click SEARCH icon.
2. Enter “Contribtuion” as the Query In table. (donation date is stored in the Contribtuions table)
3. Select “Donation Date” from the Field Name drop down box.
4. Highlight “is greater than or equal to” in the Comparison box.
5. Enter 1/1/17 as the Value.
6. Press the ADD LINE button.

7. Select “Donation Date” again from the Field Name drop down box.
8. Highlight “is less than or equal to” from the Comparison box.
9. Enter 7/31/17 as the Value.
10. Press QUERY. A list of people who gave between 1/1/17 and 7/31/17 is displayed.

A partial name criteria

In this example we’ll use a wildcard character. The wildcard in Roll Call is the @ symbol. Let’s say we want to find all the people whose first name begins with KIM.

1. Under the People menu, click on Search Profiles. Click SEARCH icon.
2. Enter “People” as the Query In table. (first name is stored in the People table)
3. Select “First Name” from the Field Name drop down box.
4. Highlight “is equal to” in the Comparison box.
5. Enter “KIM@” as the Value.
6. Press QUERY. A list of people with the first name of Kim or Kimmy or Kimberly etc. will be returned.