FetchXML Left Outer Joins - Filtering on parent of right table

(0) Share

Report

Posted on by AlexWard0707

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!

Categories:

Tables

Microsoft Dataverse