Discussions
In Insights, how to exclude Email Domains XXX.com EXCEPT one specific email "[email protected]"?

User_VCHTX
Posts: 1 Green Ribbon
I'm using filters and I can easily add an exclusion on email domains. However, I do not know how to include a specific email address that has the domain I'm excluding. Is that possible with filters or maybe SQL? If yes, how?
Thank you!
Tagged:
Answers
-
I'm not sure how performant this will be, but using SQL you can do :
("Contact"."Email Address Domain" <> 'yourDomain.com') or ("Contact"."Email Address" = '[email protected]')