Topics

Special Query

Created: 11/10/2017Updated: 11/15/2017


There are some searches that require more complex algorithms. These searches have been “pre-set” for you to use. From the results list of a query, click on the SPECIAL icon.

specialquery

Change Selection to Head

This search can only be done from within a results list. It will reduce the list to include only the Heads of Family for each family that was represented in the list. For this example let’s say we had a list of the children from our first grade class. If we choose to change to the heads of family, the children will not be in the list anymore, only the head of their family will be listed.

Change Selection to Mothers

This search can only be done from within a results list. It will change the list to include the Mothers for each family that was represented in the list. For this example let’s say we had a list of the children from our first grade class. If we choose to change to the Mothers, the children will not be in the list anymore, only the Moms will be listed.

Change Selection to Fathers

This search can only be done from within a results list. It will change the list to include the fathers for each family that was represented in the list. For this example let’s say we had a list of the children from our first grade class. If we choose to change to the fathers, the children will not be in the list anymore, only the dads will be listed.

Change Selection to Adult and all Children

This search can only be done from within a results list. It will change the list to include an adult and all the children of each family that was represented in the list. For this example let’s say we had a list of the children from our first grade class. If we choose to change to the adult and all children, the husband, wife or adult from the family plus all the children in the family will be displayed in the list.

Find Single Parents

This search finds the single parents.

Find possible blended families

This search looks for families with more than two members, where at least one person has a different last name.

Find people with picture

This search looks for individuals who have a picture in Roll Call.

Find families with a picture

This search looks for families that have a picture in Roll Call.

Find possible uninvolved families

This search allows you to specify the type of “uninvolvment”. When you select this search, the uninvolved window is displayed. You may check one or all of these boxes. If you select multiples, an AND conjunction is used. If you check the box for “hasn’t given”, you may also specify a since date. For example, I want to know what families have not given since the beginning of the year. I would check “hasn’t given”, then enter 1/1/14 as the date. If you check the box for “hasn’t attended” – this will tell you what families haven’t attended any event (worship service or group/class) in the last year.

uninvolved

If you check the box for “hasn’t joined group” – this will tell you what families haven’t recently (based on the since date) joined a group.

If you check the box for “haven’t had their record modified” – this will tell you which families have not had any of their demographic information changed since the date you specify


Was this page helpful?