News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Fetch XML linked entity

Microsoft Dynamics 365 | Integration, Dataverse...

Answered

Fetch XML linked entity

(0) Share

Report

Report

Posted on by T.I.A

1,760

Hey guys

I've got a fetch query that I can't seem to get correct. I want to use this query outside of advanced find but I cant seem to get my desired results.

I want to get appointments where the regarding is either a contact with a business category of

100000034

100000018

or accounts where the business category is

100000034

100000018

so lets say I have 3 appointments where the regarding is a contact and 5 appointments where the regarding is an account: how do I get all 8 and only the 8. Using the fetchxml tester from the XrmToolBox I'm getting more than 20 which is wrong? Any help would be appreciated guys. Here's my fetch:

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">

<entity name="appointment">

<attribute name="subject" />

<attribute name="statecode" />

<attribute name="scheduledstart" />

<attribute name="scheduledend" />

<attribute name="createdby" />

<attribute name="regardingobjectid" />

<attribute name="instancetypecode" />

<attribute name="activityid" />

<order attribute="subject" descending="false" />

<filter type="and">

<condition attribute="scheduledstart" operator="on-or-after" value="2019-04-30" />

<condition attribute="scheduledstart" operator="on-or-before" value="2020-05-30" />

</filter>

<link-entity name="account" from="accountid" to="regardingobjectid" link-type="outer" alias="ad">

<filter>

<condition attribute="exe_businesscategory" operator="in">

<value>100000034</value>

<value>100000018</value>

</condition>

</filter>

</link-entity>

<link-entity name="contact" from="contactid" to="regardingobjectid" link-type="outer" alias="ab">

<filter type="and">

<condition attribute="exe_businesscategory" operator="in">

<value>100000034</value>

<value>100000018</value>

</condition>

</filter>

</link-entity>

</entity>

</fetch>

All responses Img

All responses (6)

Answers Img

Answers (1)

T.I.A 1,760 on at

Like (0)

Report

RE: Fetch XML linked entity

Thanks Andrew, you nailed it!
a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

RE: Fetch XML linked entity

I understand. I posted wrong version initially. Can you confirm that you tested one that is posted now?
T.I.A 1,760 on at

Like (0)

Report

RE: Fetch XML linked entity

When I'm using the Fetchxml tester I get an error because the business category doesn't live on the appointment entity, it lives on the other entities (contact, account)
Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report
RE: Fetch XML linked entity

Hello,

Try to use following FetchXml:

100000034 100000018 100000034 100000018
T.I.A 1,760 on at

Like (0)

Report

RE: Fetch XML linked entity

I don't intend to use it in Dynamics directly, I'm using it in power bi to query the data
Mayank Pujara 830 on at

Like (0)

Report

RE: Fetch XML linked entity

I believe you will need to separate these two queries , one for contact and another one for account..

as far I know CRM system does not allow to set OR on two linked entities, you can set OR with in entity's attribute only...

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

Leaderboard

#1

André Arnaud de Cal... 294,095 Super User 2025 Season 1

#2

Martin Dráb 232,866 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans