HubSpot Ideas

H4ST3Y

FEATURE REQUEST: Add Boolean Operators to filters ("OR" and "NOT")

This seems like a very basic feature that I'm surprised hasn't been incorporated already, unless I'm missing something.

 

I am looking for a way to add an OR operator between filter properties, say: City = New York OR State = New Jersey. 

37 Replies
jlariccia
HubSpot Employee

As a customer support specialist, it would be ideal to have this feature available. Customers ask me about this every few weeks, so I can see the need for it. Thank you! 🙂

p2consulting
Member

Posting for visibility and updates

jenguyen
Participant

I'd really need this feature too! Now I want to filter my deals but I can't use OR in the filters. And I can't create a list of deals using Lists tool either. 

JEriksson
Member

Whats up with this, who at HubSpot will answer?

DavidYounger
Participant

I want to be able to filter tickets on Pipeline, owner and status. But not all at once.

So an OR operator is imperative. 

Other systems such as Jira has had this capability for years.

Why is such a good product as Hubspot let down by such minor but important things?

We need the OR please.

 

David Younger

theservicemanager.com

Alvaro_Sanz
Participant

Please, any news on this? Seems like a pretty basic (yet fundamental) feature, to be honest.

 

What really doesn't make any sense whatsoever is for HubSpot to not even respond to customers' comments.

FernandoVW
Member

Please allow the "OR" filtering in the Deal wiew. This is from upmost importance to cleary use this tool.

skash61
Member

Really need this to make selections of contacts where job title includes finance or admin or operations etc...

daveon
Contributor

Another vote from here - we updated a user field and I would dearly like to have a Field_1 OR Field_2 filter for identifying contacts

CCordell
Participant

Yes please to adding in OR options for filtering within companies. 

BBallard-SCID
Member

HubTags is no help. I'd have to add tags to all my contacts and there are too many. I hope the OR functionality is implemented soon. I need to search with an OR between existing fields.

GuyTaylor
Guide

Hi @BBallard-SCID,

You can run a 'OR' search using HubTags with most existing HubSpot properties. No need to tag all your contacts. Although tagging all your contacts (even if you have 100k+) takes just a few minutes. You can do this via HubSpot UI (bulk edit) or csv upload.

You can run the exact search given in this feature request via HubTags:
You can run this search with HubTags:
City = New York OR State = New Jersey 

You can also run searches like this:
Lifecycle stage = subscriber OR  buying role = end user

Feel free to ping me thru chat on our website hubtags.io if you want help getting setup or troubleshooting a issue.

Guy Taylor | HubTags.io | LinkedHub.io 

DWohlers
Member

For us, this is a must add.  This ability to section off based off "or" critieria between object fields is very important for identifying opportunities, as well as for reporting needs.  This absolutly should be native functionality, and not require a plug-in and to import or add tags.

MFall13
Contributor | Platinum Partner

Need OR filtering capaibility for object view filters! Very frustrating...

JDale
Member

I'd like "OR" in all filters across the board. Personally I need it for tickets to adjust the filters as different people are in and out of the office. If it was generally in the filter functionality, it would apply to everything (contacts, deals, tickets, etc). Very basic search and filtering functionality.

CSaunders3
Member

Definitely need more logic for filters such as OR for filtering views of tickets that I am working on. Thank you!

JDale
Member

Got added yesterday! Thanks!