FetchXML - Microsoft Dynamics 365 CRM Tips and Tricks

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… Read More »

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… Read More »