SQL Trace & FetxhXML
Dynamics CRM uses FetchXML queries. FetchXML is a proprietary query language for Dynamics CRM. Developers with a SQL background, want to find the SQL query into which the FetchXML translates. One way is to understand the FetchXML syntax, and you can also get the SQL statement with SQL Tracing to find all the SQL queries that get executed in the background when running CRM application. Note: SQL Tracing can only be executed for CRM On-Premise systems. Take an example where we have a below Fetch XML based query that is generated using advanced find. < fetch version = "1.0" output-format = "xml-platform" mapping = "logical" distinct = "false" > < entity name = "account" > < attribute name = "name" /> < attribute name = "primarycontactid" /> < attribute name = "telephone1″ /> <attribute name=" accountid " /> < order attribute = ...