Dynamics 365 CRM and the platform underneath has always provided for a proprietary query language called FetchXML. With the introduction of CRM Online, this became the defacto query language as SQL commands could no longer be used (well querying data through sql is being reintroduced, under preview right now, but that is another topic for… Read More »
Recently while working in Dynamics 365 CRM we were facing the strange issue while retrieving more than 5K records using Web API with FetchXML The issue occurred when we retrieved more than 5K records using Web API with FetchXML, it was returning the same paging cookie everytime as shown below. “<cookie page=”1″><fullname last=”D. DAVID” first=”FRAN HUANG” /><contactid… Read More »
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… Read More »
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 »