Hi,
I'm creating a view of Leads where I want to see all leads that has a campaign response for "My campaign" that is of a certain response code.
The problem is that I want to exclude leads that have a campaign response with a different response code and when I do - I still get them in my list because they have multiple campagin responses with different response codes.
My query is
Leads:
Activity Parties(Party)
. Activity(Campaign response)
. .Response code Equals "Interested"
. .Response code Does Not Equal "Not interested"
. .Parent Campaign Equals "My campaign"
Result show leads that have "Not Interested"-responses, which obviously isn't what I want.
I want to see all leads that have an "Interested"-response but NOT if they also have a "Not interested"-response..
Any help would be appreciated!