News and Announcements icon

Dynamics 365 CommunityForums Dynamics 365 general forum How to get E-Mails wit...

Dynamics 365 general forum

Answered

How to get E-Mails without ActivityParty of type 'Contact'?

(0) Share

Report

Report

Posted on by alx.kpk

21

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?

Categories:

Customization / Solutions / SDK and API

All responses Img

All responses (3)

Answers Img

Answers (1)

alx.kpk 21 on at

Like (0)

Report

RE: How to get E-Mails without ActivityParty of type 'Contact'?

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!
alx.kpk 21 on at

Like (0)

Report

RE: How to get E-Mails without ActivityParty of type 'Contact'?

Thanks for the input. Unfortunately this FetchXML query returns 0 records.
Verified answer

a33ik 84,321 Most Valuable Professional on at

Like (1)

Report
RE: How to get E-Mails without ActivityParty of type 'Contact'?

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,554 Super User 2024 Season 2

#2

Martin Dráb 228,588 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans