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 Toronto.
His
residence postal code and phone number are in two other fields.
If you need
to find everyone in your database who lives in a particular city. That
information is stored in the Residence City field in contact records.
To
do this you must open the contacts list, choose the Search Type: Field,
then choose the field to search, in this case Residence City.
Then
choose the appropriate Search Operator. "Search Operators" tell Sumac
the relationship between the field you're searching in, and the value you're
looking for within that field.
If you would want to find everyone who lives in Toronto, choose the Search Operator: "is equal to", then type “Toronto” into the search value field.
That tells Sumac to find contacts whose Residence City field is equal to Toronto.
Click Search and Sumac displays the results.
Each Search Operator has a particular function.
“Is equal to” searches for records in the database that match the search value that you enter. (searches are not case sensitive.)
“Not equal to” on the other hand finds all records in the database that do not match the specified search value. To find all the contacts who do not live in Toronto, change the search operator, and click Search again.
You can find records with value bigger or smaller than the value you enter. For text fields, this works alphabetically: A is considered to be less than Z.
“Is null” finds records in the database where the field you are searching is empty.
Related Articles
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 ...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 ...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 ...How to build a custom contact list using List Builder
List Builder lets you build a list of specific contacts by dragging and dropping them into the List Builder Window. You can search across different areas of Sumac CRM, compile those results in one list, and then take advantage of the tools in the ...How to clean Data using Import Workspace
If you have a spreadsheet full of contact information, like names and addresses, you can use Sumac to validate the information before importing. Sumac does not allow you to import incorrect information, so you must clean up and validate the data ...
- 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.