Left join in FetchXml?

10,665

Update your <link-entity> like so:

<link-entity name='address' from='addressid' to='addressid' link-type='outer'>
Share:
10,665

Related videos on Youtube

Luke Baulch
Author by

Luke Baulch

Updated on June 04, 2022

Comments

  • Luke Baulch
    Luke Baulch over 1 year

    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>
    

Related