You’re offline. This is a read only version of the page.
Hi all,
I'm trying to build a 'not in' FetchXML query using a left outer join, I've been successful in creating a simple one where for example, I want to list all Accounts where all child Contacts do not have a Status of X. However, is it possible to filter based on a parent table of the Contact, e.g show me all Accounts where the parent record Y on all child Contacts does not have a Status of X? I can't seem to figure out whether it should be an inner or outer join, whether I need to be using aliases, etc. I've tried loads of variations with no luck, has anyone done this before? Thanks in advance!
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
Super User 2025 Season 2
#3
mmbr1606
275
Super User 2025 Season 2
Share
Report
All responses (
Answers (