As we’ve covered pretty extensively on the blog lately, Microsoft Dynamics CRM 2013 has a ton of new great features. One of the things we haven’t covered yet is the new ability to perform left outer join queries using FetchXML. So let’s dive in!
Below you’ll see an account record that doesn’t have any cases.
To query for accounts that don’t have cases, you can use the following FetchXML query:
The two main pieces to specify are the link-type, which is part of the link-entity, and the operator of the condition of a filter. Set the link-type to outer and the operator to null.
Below is a screenshot of the results when the RetrieveMultiple request is executed.
In order to use this left join inside CRM 2013, use the SavedQuery entity to create a view.
Once executed, you can now see this left join view.
There you have it—that’s how to perform a left join using FetchXML and display results in Microsoft Dynamics CRM 2013!