340
How to relate these three entities where entity A is lookup in both entity B and entity C. And get the detail information by retrieving fields from all the three entities
*This post is locked for comments
Hi
Use XrmToolBox
Example fetchXml:
Share
Report
All responses (
Answers (
<fetch top="50" >
<entity name="account" >
<attribute name="address1_city" />
<attribute name="name" />
<attribute name="accountnumber" />
<filter>
<condition attribute="createdon" operator="last-x-days" value="90" />
</filter>
<link-entity name="contact" from="parentcustomerid" to="accountid" alias="cont" >
<attribute name="gendercode" />
<attribute name="lastname" />
<attribute name="firstname" />
</link-entity>
<link-entity name="opportunity" from="customerid" to="accountid" alias="Opp" >
<attribute name="actualvalue" />
<attribute name="name" />
<attribute name="totalamount" />
</link-entity>
</entity>
</fetch>
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156