Dynamics CRM Support Blog
Problems configuring the CRM Outlook client? Use the wizard!
CRM Resource Center
FAQ About Technical SupportOnline | On-Premise
FAQ About Billing
Implementation Guide
Microsoft Dynamics CRM Developer Center and SDK
Hello - Is there a way to convert Fetch XML to SQL? SQL is a lot easier for me to read and debug in SSMS so I can see what the SQL is doing, where it's getting it's data and I can easily run different queries/subqueries for validation, etc. I would think that since CRM has been around for a while and has gone through several versions that CRM would have a native tool to do this conversion. Here's an example block of Fetch XML:
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false"> <entity name="new_aeassignment"> <attribute name="new_comptype" /> <attribute name="new_aeassignmentid" /> <order attribute="new_comptype" descending="false" /> <link-entity name="new_ae" from="new_aeid" to="new_aeid" visible="false" link-type="outer" alias="a_1e32bfce6d3c40aba4d982fa40733806"> <attribute name="ownerid" /> <attribute name="new_aeoffice" /> </link-entity> </entity></fetch>