Tag Archives: FetchXML

Validate FetchXml by using ValidateFetchXmlExpression WebAPI function in the script

Introduction: In a recent project, we retrieved Dynamics 365 CRM data using WebAPI and fetchXml expressions. In most cases, we create fetchXml expressions, where we add attributes and filter conditions dynamically in the fetchXml.  When we execute our dynamically created fetchXml expressions, it fails with  different error messages. Here we had come across a requirement… Read More: Validate FetchXml by using ValidateFetchXmlExpression WebAPI function in the script »

How to solve “When using arithmetic values in Fetch a ProxyTypesAssembly must be used in order to know which types to cast values to” while using Fake XRM Easy

Introduction While using Fake XRM Easy for Plug-in or Workflow unit testing, there could be situations that could arise where we need to use fetchXML to retrieve some records. While it works for most of the time, it can be tricky while working with some attributes statecode for starters. In the above fetchXML, “<condition attribute=”statecode”… Read More: How to solve “When using arithmetic values in Fetch a… »

Field Comparisons now available for Queries in Power Platform

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: Field Comparisons now available for Queries in Power Platform »

Execute multiple FetchXML and OData queries using Batch request

We have developed an application to fulfill one of our clients’ requirement. In that application we have perform multiple retrieval operation from CRM (around 10) either using FetchXML or OData of different entities. So, when we retrieve records from Dynamics 365 CRM of different entities for each retrieve operation it takes around 300 milliseconds and… Read More: Execute multiple FetchXML and OData queries using Batch request »

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: Use WEB API Batch Request in Dynamics 365 to execute… »

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: Inogic’s Top 10 Most Popular Dynamics CRM Blogs of 2014 »

How to handle Special Characters in Fetch XML

Fetch XML, the easiest way to write complex queries to retrieve data by joining multiple entities. Though being the easiest, we were still stuck at a point where we didn’t know what to do. We were getting Invalid XML error. For quite some time we were wondering what could have caused this. Below is our… Read More: How to handle Special Characters in Fetch XML »

Update fetch query of System/User view dynamically

Based on the client requirement sometimes it is needed to update the system/user view to filter record as per needed. In your query you need to apply outer join which won’t be possible through Advanced Find so in that case you need to update the fetch query of System/User view dynamically. Below is the sample… Read More: Update fetch query of System/User view dynamically »

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: Use SQL Tracing to find the SQL query generated for… »

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… Read More: Use of Alias in FetchXML »