Contacts

How can I use an OR or AND operator in my HubSpot CRM filter?

Last updated: December 16, 2016

Available For:

Marketing: N/A
Sales: Free, Professional

The OR search operator

You can use an OR operator to search for multiple types of results in a given property. For instance, if you are looking for contacts in your database that are located in Boston or New York, you can enter your search so that City / contains / "Boston" OR "New York": 

Please note that the OR operator must be in all capital letters. You can also combine an OR operator search with a wildcard search using the * search function . For instance, if you want to filter freemail addresses, you can build a filter that looks like this:

  

The AND search operator

The AND search operator is used to search for multiple values within a single property entry. For instance, if you want to search for all results that have both hello and gmail.com in the email, try a search like the below:

 

Please note that the AND operator must be in all capital letters. With this filter, you'll segment out contacts whose email address includes both values, such as hellokatie@gmail.com.