The tool will assist in three major areas: 1. Constructing FetchXML in ways that Advanced Find cannot - aggregates - outer joins - "has no"-queries - attributes from multi-level linked entities 2. Querying CRM for information not (easily) found in the CRM UI - system / internal entities - attributes hidden in CRM UI - join on other fields than relationships 3. Developer assistance - Generate C# QueryExpression code from fetch xml - Generate OData query string from fetch xml - Easy to use UI to compose queries for reports in CRM The tool reads metadata from CRM to assist with selecting entities, attributes, relations and to perform validation of condition values. To make it more appealing, there is also the possibility to have it show "Friendly names", which will replace the technical names of entities and attributes with their display names in the users' currently selected language, much like Advanced Find does.
Project Url
View on NuGet:


Here are the packages that version 1.2017.8.1 of Cinteros.Xrm.FetchXmlBuilder depends on.

EngineeredCode.XrmToolBox.Portalsv7Tov8Cleanup : (1.2018.7.20)



Installing with NuGet

PM> Install-Package Cinteros.Xrm.FetchXmlBuilder -Version 1.2017.8.1

Packages that Depend on Cinteros.Xrm.FetchXmlBuilder

No packages were found that depend on version 1.2017.8.1.