Friday, October 25, 2013

Dynamics 2013 - FetchXML now supports left outer joins

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>

Wednesday, October 16, 2013

Dynamics CRM 2013 available in Ireland

If you register for a Dynamics CRM trial in Ireland you will now get provisioned with the 2013 release which is significantly different from the 2011 version. There have been major improvements in the user interface in Dynamics CRM 2013. Microsoft has succeeded in making the UI more usable to promote user adoption.   

The UI in versions prior to this could be a little bit daunting for new users with lots of buttons, icons and multiple browser windows open.  Dynamics CRM 2013 has adopted a SPA, single page architecture, with a more responsive and cleaner user interface.