You’re offline. This is a read only version of the page.
Let's say I have two interest types for my contacts: tennis and golf. Some contacts are interested in tennis, some in golf, and some are interested in both. Using Advanced Find, is there a way to search for contacts that are interested in only one of these two? For example, say I'm trying to run a search for contacts interested in golf, but not interested in tennis. I would think my search should be set up as such:
Look for: Contacts
Related Field: Interests (Contact)
Interest Type Equals Golf
Interest Type Does not Equal Tennis
However, this does not work. This search would result in a list of contacts who are interested in golf, but it does not exclude from that contacts who are also interested in tennis. It appears as if CRM only looks at one interest type at a time, and can't compare a contacts interests to each other. My question is this: How would I, using Advanced Find, procure a list of contacts interested in golf, but not additionally interested in tennis? Is this achievable?
Thank you for your help,
A Confused Intern
*This post is locked for comments
It looks like your Interests are in a separate entity with the contact having a one-to-many relationship with interests. Is that correct? If so, you might be able to pull them all into a marketing list and then remove those with an interest in tennis.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (