Using Groups in Search Builder

For any search that you run, there will always be a Group condition to hold all other conditions. Whenever you create a new search, the dialog with the list of Conditions will open automatically. If you do not select a Condition and run the search with an empty Group, you will get everybody in the database, except for deceased people.

So, you need to select a Condition and save it to the Group in order to filter the list. To add other Conditions, click the green +Condition button.

Then once you have a condition, and configure it, click the Save button. If you don’t save the condition, it will not get added to the search.

You can change the Condition after you have added it to your search by clicking on the name of the Condition, then clicking on the drop down arrow and selecting Change Condition.

https://i.tpsdb.com/2016-08-17_08-05-20.png

A Group condition has four types of comparisons that affect how conditions are combined within the group. The default comparison is Match All. This means that all conditions must be true within the group for the person to pass through the filter and show up in your results.

The comparisons are:

  1. Match All - all conditions must be true for the person to be included

  2. Match Any - if at least one of the conditions is true, the person will be included

  3. Match None - all conditions must be false for the person to be included

  4. Match Not All - if at least one of the conditions is false, the person will be included

For those of you who understand the language of boolean expressions here’s the equivalent:

Match ALL true would be like this:

  • x=true AND y=true AND z=true

  • where x, y and z are conditions that evaluate to true/false

Match ANY true would be like this:

  • x=true OR y=true OR z=true

Match NONE true would be like this:

  • x=false AND y=false AND z=false

Match NOT ALL true would be like this:

  • x=false OR y=false OR z=false

A Group condition can also hold as one of its conditions another Group condition. This way you can nest conditions together and each Group can have its own comparison (one of the four above).

You could construct a search like:

  • x=true AND (y=true OR z=TRUE)

You add a group condition above an existing condition by clicking the Gear Icon > Insert Group Above This.

https://i.tpsdb.com/hayley-SBInsertGroup.png

You can add a group below your existing group by selecting the green +Group button.

Sample Search with Multiple Groups

This is an example of a search with 3 groups. Note that the top group has Match ANY and the other 2 groups are nested below the top group.

To fit the criteria, a person must meet the conditions in either of the other 2 groups.

In group 2, the top Condition is Match ALL. Anyone meeting the criteria would be a church member and have a Resident Code of Metro or Marginal.

In group 3, the top Condition is Match ANY. Anyone meeting those criteria would either have attended something recently or has joined something recently.

All people in the search results will be:

  • A church member

  • Living in the local area

OR

  • Has attended something recently

  • Or has joined something recently

https://i.tpsdb.com/hayley-SBGroups.png

This purpose of this article is to explain how groups work. For more about how to build searches you will want to see our other help articles and videos.

See also

How to Use Search Builder - includes several videos
Search Builder Facts and Tips - includes link to Search Builder playlist in YouTube

Each Condition also has its own help article that you can access from within the dialog for Conditions by clicking the ?Help Article button beside the name of the Condition. There is also a list of all Conditions with links to the help articles on the Search Builder index.

See also

Search Builder



Latest Update

11/13/2020

Modify image link with secure protocol.