Tag Archives: FetchXML

Use WEB API Batch Request in Dynamics 365 to execute long FetchXML

Introduction: Recently we had a project where we use WEB API for retrieve the records from Dynamics CRM. In our project, we dynamically create FetchXML to retrieve records but sometimes Fetchxml have a lot of columns and conditions etc so its length get increase and we this the fetchxml in URL which violates the browser… Read More »

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

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

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 »