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

Last updated: July 7, 2017

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 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 

Was this article helpful?