Before creating a Power Search you must carefully consider the criteria you need in your search and how these criteria should be combined to create the desired result.
One thing to remember about any power search is that the results are based on contact records only. That is, contact records that meet the criteria you have entered will be returned.
Remember that a power search returns Contact Records ONLY. Searching for DONATION >= $100 searches for contact records that have donations greater than or equal to $100, not individual donations. Other donations are not filtered out. |
There are two ways of combining criteria in a Power Search. You can create either an OR statement or an AND statement.
The statements used in this search can be found under the Contact Attributes folder
OR statement – search statements in an OR search will be treated as separate statements.
•The power search will look for and return contact records that satisfy ANY of the criteria.
•In the example below the search will return all contact records
-where the gender is set to male and
-all contact records where the age is younger than 35 (this will include both men and women).
AND statement – results from search statements in an AND search will be combined.
•The power search will look for and return only contact records that satisfy EACH statement.
•In the example below the search will return all contact records where
-the gender is set to male AND the age is younger than 35
That is, all the men who are younger than 35.
To construct an AND search we use the Add button and the Add to highlighted condition check box.
To construct an OR search we use the Add button to add search statements to the power search.