Left join in FetchXml?
10,665
Update your <link-entity>
like so:
<link-entity name='address' from='addressid' to='addressid' link-type='outer'>
Related videos on Youtube
Author by
Luke Baulch
Updated on June 04, 2022Comments
-
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>