Tag Archives: FetchXML

Inogic’s Top 10 Most Popular Dynamics CRM Blogs of 2014

This blog in the beginning of New Year brings you the Top 10 interesting and useful blogs posted by us during the year 2014. This article consists of content from blogs that belong to CRM 2013 and which have been the most visited, re-tweeted and commented blogs of Inogic. Hope these set of blogs are resourceful and help you some way […]

Use SQL Tracing to find the SQL query generated for Dynamics CRM Platform Operations for CRM On-Premise

Dynamics CRM works largely on FetchXML queries. FetchXML is a proprietary query language for Dynamics CRM. For developers coming from SQL background, they would really want to find the SQL query that the FetchXML translates into. While one way is to explain the FetchXML syntax, it might help to also get the SQL statement that […]

Use of Alias in FetchXML

Introduction: I am sure by now almost anyone developing on Dynamics CRM would have had experience working with FetchXML queries, the Dynamics CRM proprietary format to query data using Dynamics CRM SDK API. We recently came across a scenario where we needed to use an alias for an attribute. Similar to the SQL query Select […]

Aggregate and Grouping functions using LINQ in CRM

As you know, QueryExpression are built as an Object Model. They support all the features of FetchXML except for grouping & aggregates. FetchXML supports all the features of QueryExpression including grouping & aggregates. Queries here are built as XML statements. LINQ queries are built using standard language similar to SQL, but internally it uses QueryExpression […]

Group by using FetchXML

In Microsoft Dynamics CRM 2011 FetchXML includes grouping and aggregation features which let us to use aggregate functions like sum, count etc. Using Group by we can calculate sum, avg, min, max, count. But, Group by clause is not supported through LINQ in CRM. You can only specify one aggregate attribute in a query and you cannot […]