dynamics-crmdynamics-crm-4fetchxml

Left join in FetchXml?


How do i do a left join using FetchXml?

Consider a simple SQL query like the following:

select person.name, address.city from person
left join address on person.addressid = address.addressid

How would something simple like this be done using FetchXml? Currently my FetchXml query looks like the following:

<fetch mapping='logical'>
  <entity name='person'>
    <attribute name='name' />
    <link-entity name='address' from='addressid' to='addressid'>
      <attribute name='city' />
    </link-entity>
  </entity>
</fetch>

Solution

  • Update your <link-entity> like so:

    <link-entity name='address' from='addressid' to='addressid' link-type='outer'>