• Home
  • Blog
  • About Me
  • Home
  • Blog
  • About Me
Dynamics 365

Dynamics 2013 – FetchXML now supports left outer joins

By Joe Gill  Published On 25th October 2013
Dynamics 2013 has now added support for left outer joins in FetchXML. So you can now easily do queries like get all the accounts with no contacts.

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="account">
<attribute name="name" />
<link-entity name="contact" from="parentcustomerid" to="accountid" link-type="outer">
<attribute name="parentcustomerid" />
</link-entity>
<filter type='and'>
<condition entityname="contact" attribute="parentcustomerid" operator="null"/>
</filter>
</entity>
</fetch>

Leave A Reply Cancel reply

You must be logged in to post a comment.

Dynamics CRM 2013 available in Ireland
Previous Article
Dynamics CRM 2013 - Business Rules Limitations
Next Article