Cinteros.Xrm.FetchXMLBuilder 1.2022.11.2

.NET Framework 4.7.2
dotnet add package Cinteros.Xrm.FetchXMLBuilder --version 1.2022.11.2
NuGet\Install-Package Cinteros.Xrm.FetchXMLBuilder -Version 1.2022.11.2
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Cinteros.Xrm.FetchXMLBuilder" Version="1.2022.11.2" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Cinteros.Xrm.FetchXMLBuilder --version 1.2022.11.2
#r "nuget: Cinteros.Xrm.FetchXMLBuilder, 1.2022.11.2"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install Cinteros.Xrm.FetchXMLBuilder as a Cake Addin
#addin nuget:?package=Cinteros.Xrm.FetchXMLBuilder&version=1.2022.11.2

// Install Cinteros.Xrm.FetchXMLBuilder as a Cake Tool
#tool nuget:?package=Cinteros.Xrm.FetchXMLBuilder&version=1.2022.11.2

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

Read more: https://fetchxmlbuilder.com/

FetchXML Builder is used to create and execute queries against Microsoft Dataverse / Power Apps / Dynamics 365.
The Power Platform includes technologies we know as:
- Microsoft Dynamics 365
- Dynamics CRM
- XRM
- Power Apps (Model Driven)
- Power Apps (Canvas connected to Dataverse)
- PowerBI (connected to Dataverse)
- Microsoft Teams for Dataverse

The tool will assist in three major areas:

1. Constructing queries, including more advanced features like:
- aggregates
- outer joins
- complex "not-in"-queries
- attributes from multi-level linked entities
- update existing views with altered queries

2. Querying CDS/CRM for information not (easily) found in the UI
- system / internal entities
- attributes hidden in CRM UI
- join on other fields than relationships

3. Developer assistance generating code for
- C# QueryExpression code
- WebAPI / OData query string
- Power Automate List Records
- SQL, JavaScript and C# stubs
- Easy to use UI to compose queries for reports in CRM

The tool reads metadata from Microsoft Dataverse and Dynamics 365 / 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.

Product Versions
.NET Framework net472 net48
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
1.2022.11.2 4,252 11/23/2022
1.2022.8.1 18,611 8/20/2022
1.2022.5.1 26,859 5/29/2022
1.2022.4.1 10,840 4/24/2022
1.2022.3.1 13,987 3/1/2022
1.2022.2.2 7,739 2/7/2022
1.2022.2.1 685 2/6/2022
1.2022.1.5 2,866 1/31/2022
1.2022.1.4 5,011 1/19/2022
1.2022.1.3 1,678 1/17/2022
1.2022.1.2 1,066 1/16/2022
1.2021.10.2 22,027 10/6/2021
1.2021.4.4 33,083 4/1/2021
1.2020.12.3 20,092 12/15/2020
1.2020.12.2 838 12/14/2020
1.2020.11.2 8,800 11/13/2020
1.2020.11.1 1,466 11/11/2020
1.2020.9.1 12,061 9/21/2020
1.2020.7.3 11,279 7/22/2020
1.2020.6.2 8,827 6/7/2020
1.2020.5.7 4,728 5/23/2020
1.2019.12.1 22,781 12/2/2019
1.2019.9.1 16,298 9/10/2019
1.2019.4.1 23,062 4/8/2019
1.2019.3.7 7,292 3/15/2019
1.2019.3.6 2,657 3/12/2019
1.2018.12.5 14,363 12/18/2018
1.2018.12.2 2,379 12/14/2018
1.2018.12.1 985 12/14/2018
1.2018.8.2 16,443 8/30/2018
1.2018.6.1 12,922 6/15/2018
1.2018.4.2 14,825 4/6/2018
1.2018.2.2 14,425 2/12/2018
1.2018.2.1 5,820 2/1/2018
1.2018.1.3 12,549 1/5/2018
1.2017.10.4 30,175 10/25/2017
1.2017.10.3 4,623 10/24/2017
1.2017.8.1 34,478 8/3/2017
1.2017.6.119 36,660 6/13/2017
1.2017.2.117 57,124 2/9/2017
1.2016.12.115 36,863 12/13/2016
1.2016.7.113 30,886 7/7/2016
1.2016.6.111 8,045 6/23/2016
1.2016.5.109 7,216 5/26/2016
1.2016.5.107 4,816 5/12/2016
1.2016.4.106 3,299 4/28/2016