Which Connector Should I use in Search Builder?

Which Connector Should I use in Search Builder?

    Here’s a picture to help you understand the connector you need to use to find what you want.

    Example Criteria

    Suppose Criterion 1 is:
    Has a Beard
    Has a beard criterion
    Suppose Criterion 2 is:
    Wears Glasses
    Has glasses criterion

    Results

    Here are the results you will get for each connector:

    AND
    Result = Only people who meet both criteria
    Has beard and glasses
    OR
    Result = People who meet both criteria, or just one
    Has beard and glasses
    Has beard
    Has glasses
    XOR
    Result = People who meet only one criterion
    Has beard
    Has glasses


    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

      • 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 ...
      • Using Search Builder to find all contacts who might be linked to the same membership record

        When trying to find contacts who have memberships matching assorted criteria, you can use Search Builder to find contacts who are listed in the Member field, or the Member 2, 3, 4, 5, 6 or Billing Contact fields of their corresponding membership ...
      • 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 ...
      • 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 ...
      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.