Link multiple entities with FetchXML

(0) Share

Report

Posted on by Community Member

I have a requirement to fetch all the activities from custom entities and have it roll up into a parent custom entity. I tried to use the cascade all option on the relationships but I guess that dosnt work for custom entities for whatever reason. So Im stuck trying to code it. I have been trying to get the fetchXML working but I'm having difficulty linking two different entities and I'm not sure what is wrong. Im using the XRMToolBox FetchXML builder and when I run it it just tells me its invalid XML. I'm not sure what Im doing wrong. Any help is appreciated!

Salestrip being parent, Customer Visit being child and Account Affected being grandchild

XML below.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Dynamics365 Rocker 7,755 on at

Like (1)

Report

Have you checked in XRM tool XML checker?

Try it after removing:

<link-entity name="salestrip" from="salestripid" to="regardingobjectid" link-type="outer" >

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I got it to where its working, and it returns the records for the first condition. I am having trouble getting it return records for both conditions. Ive tried adding a second filter and changing filter type between OR and AND.

<fetch top="50" >

<entity name="activitypointer" >

<attribute name="createdon" />

<attribute name="activityid" />

<attribute name="prioritycode" />

<attribute name="statecode" />

<attribute name="regardingobjectid" />

<attribute name="subject" />

<filter type="or" >

<condition entityname="accountaffected" attribute="originatingtrip" operator="not-null" />

<condition entityname="customervisit" attribute="originatingtrip" operator="not-null" />

</filter>

<link-entity name="accountaffected" from="accountaffectedid" to="regardingobjectid" link-type="outer" />

<link-entity name="customervisit" from="acntcustomervisitid" to="regardingobjectid" link-type="outer" />

</entity>

</fetch>

Was this reply helpful? Yes No
David Jennaway 14,065 on at

Like (0)

Report

The structure of your FetchXml is correct. Are you sure each link-entity and condition is correct (you can test by selectively removing the conditions) ? And is what you posted the complete FetchXml - you refer to a 'second filter', but the above only has one filter expression, and also the custom fields don't have a prefix, so maybe you've made an error entering this into your post

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I tried adding a second filter to see if it would work. I did get it working I had the wrong field for one of the linked entities.

Was this reply helpful? Yes No