Let’s say you wanted to set criteria that accomplished the following:
- Company name is not blank; AND
- Email excludes generic email addresses on the standard Lead field “Email”. The API name for that field in Salesforce is Email.
After selecting your filters then clicking on Generate Filter, your output will look like this:
Company!= null AND Email NOT LIKE '%yahoo.com,gmail.com,hotmail.com,live.com,outlook.com%'
You’ll need to modify your query to look like this: Parenthesis have been highlighted in red to make the necessary changes more obvious
Company!= null AND (NOT Email LIKE '%yahoo.com') AND (NOT Email LIKE '%gmail.com') AND (NOT Email LIKE '%hotmail.com') AND (NOT Email LIKE '%live.com') AND (NOT Email LIKE '%outlook.com')