Become a HubSpot power user — join us for HubSpot Training Day 2017.

Contacts

How can I use an OR or AND operator in my contacts or companies filter?

Last updated: September 18, 2017

Available For:

Marketing: Free, Starter, Basic, Pro, Enterprise
Sales: Free, Professional
Yes. In your filtered views, you can use an AND or OR operator to pull up different records that meet your criteria.

 

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

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. 

Was this article helpful?