I'm trying to get all email records which have no relationship to a contact. Here is my current FetchXML:
It also returns records that have contacts as ActivityParty. Do I miss something here or is this a limitation of FetchXML?
I'm trying to get all email records which have no relationship to a contact. Here is my current FetchXML:
It also returns records that have contacts as ActivityParty. Do I miss something here or is this a limitation of FetchXML?
Sorry, I was wrong. I oversaw the meaning of entityname="ap" in the condition and didn't notice FetchXML Builder is not using this attribute. Query seems to work pretty fine. Thanks a lot!
Thanks for the input. Unfortunately this FetchXML query returns 0 records.
Hello,
Check the following FetchXml:
Check this KB that explains how it works - docs.microsoft.com/.../use-fetchxml-left-outer-join-query-records-not-in
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,554 Super User 2024 Season 2
Martin Dráb 228,588 Most Valuable Professional
nmaenpaa 101,148