Searching in list using multiple search criteria
Searching Donations
On the Sumac Dashboard, expand Fundraising and click Donations.
The search area always appears at the top of a list.
The Search Type menu in the Donations list holds search criteria that relate to donations, such as when donations were received, the donor's name, donation type, or campaign.
If we want to find donations that were made last week, we search
by the When Received date field.
You can either specify each date or use the drop-down menu to choose the time period you're
interested in such as Last Week. If you choose Last Week, Sumac fills in the dates of
last week. Click Search, and Sumac finds all the donations received last
week!
Searching with Multiple Criteria
Example 1
In this example we'll search for all donations made in the last month to a
certain campaign. In this example, we're looking for a list of
donations that match two different criteria: one criterion for
donations made in the last month, and another criterion for
donations made to a specific campaign.
First, specify the date range search criterion. For this example,
choose a time period of Last Month.
Next, add another criterion to specify the campaign. To add a second criterion, click the Plus
sign.
Sumac adds a second criterion for this search. Notice that you must also specify the connection between these two criteria. The options are “And,” or “Or.” Selecting And means a record must match both criteria to be included; selecting Or means a record must match one or the other of the criteria selected.
For this example, I'll choose to use an “And” connector because in our example we want
to find the donations made during the last month AND to a
specific campaign.
Next, choose Search Type: Campaign
and its Children and select Annual
Campaign.
Click Search, and Sumac finds all the donations in the database
that match this time period and the specified campaign.
Example 2
In this example, we'll find donations in the last quarter for an education fund or that were made for an event. We'll build our search based on three basic criteria: the education fund, an event, and timeframe.
In order for this search to work, the fund and event must have been added to each donation.
First, let's set our criterion to find donations made to the event. Choose the Search Type: Event, then click Choose Event to select
the event you want to include.
Next, specify the date range. Choose the Search Type: When Received, then set the date range "last quarter." Since we want donations either to the fund OR to the event, change the AND to an OR.
Remember to click the Plus button to add additional criterion.
Now add a criterion to find donations made to the Education Fund. Choose the Search Type: Fund, then choose the Education Fund. Again specify the date range of interest.
Now there are 4 search criteria.
Sumac performs AND operations before it performs OR
operations, so the first two are grouped together and performed to
find donations to an event in a date range. Then the next two
search criteria are performed to find donations to a fund in a date
range.
Then they are all combined together with the OR operator.
Click Search and Sumac finds all the donations that match the criteria specified.
Membership search
For this example, we'll perform a common search to run in the Memberships list - searching for memberships that are going to expire soon and
haven't renewed their membership yet.
On the Sumac Dashboard, click Memberships to open the console.
First, select the Search Type: Expiring in Date
Range. Then choose the date range you are interested in.
There is a check box here labeled “Not yet
renewed.” This check box tells Sumac to find only memberships
that meet the above criterion and have not yet been renewed. Click Search, and Sumac finds all the membership records that
will expire in specified time period that have not yet renewed.
The same basic approach to searching is applicable
in every list area of Sumac.
Our products got an upgrade!
Some screenshots and help videos have been made using older versions of our products. Though your version's colours and themes may appear different than what you see here, the instructions, links and advice in this article are still accurate and useful!
Related Articles
Searching in a list using Operators
This article explains search operators. A database record is made of many little pieces of data which are stored in fields. When you search, you are looking for specific data in specific fields. In this example, we'll search for contacts living in ...Basic Concept of Searching in Sumac
The Benefits of Effective Searching Sumac has powerful searching capabilities so you can find anything in your database; contacts, donation information, client and volunteer data, memberships, tickets, and more. This article covers basic searching ...Searching in list: Tips and Troubleshooting
If you run a search in Sumac and get some unexpected results, review your search criteria to ensure that they are correct, and reflect on what you're trying to find. Common reasons for unexpected search results Search criteria are not specific ...My search options have disappeared
Sumac has powerful searching capabilities so you can find anything in your database; contacts, donation information, client and volunteer data, memberships, tickets, everything! With the new simple search, you are able to search the records with the ...How to use Search Builder
Search Builder lets you search for contacts based on any criteria in the database, such as contact type and donation information. In this example, we'll look at creating a mailing list for a holiday campaign. We'll send solicitation letters to anyone ...
Societ Academy
Learn what you need to know, any time. Free!
- High quality training on demand - sessions are available every day, so you can access training that fits into your schedule.
- Training sessions that are easy to follow - helpful tips throughout each session, and access to training moderators ensure your questions get answered.
- A certificate of completion - you can request a certificate of completion for every session you attend.