The tool will assist in three major areas: 1. Constructing FetchXML in ways that Advanced Find cannot - aggregates - outer joins - complex "not-in"-queries - attributes from multi-level linked entities - update existing views with altered queries 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 - Generate SQL, JavaScript and C# stubs for queries - 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 even 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.


Keywords
Builder, XrmToolBox, Plugins, FetchXML, microsoft-dynamics-crm
License
GPL-3.0
Install
Install-Package Cinteros.Xrm.FetchXmlBuilder -Version 1.2018.8.2

Documentation

FXB FetchXML Builder for XrmToolBox

Build queries for Microsoft Dataverse and the Power Platform. Investigate data. Get code. Empower yourself to achieve more.

Works well with Microsoft Dynamics CRM 2011-2016 and Microsoft Dynamics 365 and Power Platform, online and onprem.

Written by Jonas Rapp, Stockholm, Sweden.

Follow FetchXML Builder on Twitter!


Need more info?

Visit the FetchXML Builder homepage at https://fetchxmlbuilder.com !


Questions? Feedback? Praise?

Visit the FetchXML Builder forum at https://fetchxmlbuilder.com/forum !