Cinteros.Xrm.FetchXmlBuilder 1.2019.4.1

.NET Framework 4.5.2 This package targets .NET Framework 4.5.2. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package Cinteros.Xrm.FetchXmlBuilder --version 1.2019.4.1                

                    
                

            
NuGet\Install-Package Cinteros.Xrm.FetchXmlBuilder -Version 1.2019.4.1
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.2019.4.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add Cinteros.Xrm.FetchXmlBuilder --version 1.2019.4.1                

                    
                

            
#r "nuget: Cinteros.Xrm.FetchXmlBuilder, 1.2019.4.1"
#r directive can be used in F# Interactive and Polyglot Notebooks. 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.2019.4.1

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

FetchXML Builder is used to create queries against CDS databases.
CDS includes technologies we know as:
- Microsoft Dynamics 365 Customer Engagement
- Dynamics CRM
- Common Data Service for Apps
- XRM
- PowerApps (Model Driven)
- PowerApps (Canvas connected to D365 or CDS)
- PowerBI (connected to D365 or CDS)
     
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
- Microsoft Flow List Records parameters
- SQL, JavaScript and C# stubs
- Easy to use UI to compose queries for reports in CRM

The tool reads metadata from CDS 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 Compatible and additional computed target framework versions.
.NET Framework net452 is compatible.  net46 was computed.  net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
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.2024.10.1 18,501 10/5/2024
1.2024.9.3 15,297 9/4/2024
1.2024.4.1 33,099 4/27/2024
1.2023.11.1 43,274 11/12/2023
1.2023.8.2 27,623 8/21/2023
1.2023.8.1 6,051 8/13/2023
1.2023.2.2 40,625 2/14/2023
1.2022.11.2 20,380 11/23/2022
1.2022.8.1 20,379 8/20/2022
1.2022.5.1 31,589 5/29/2022
1.2022.4.1 12,388 4/24/2022
1.2022.3.1 15,591 3/1/2022
1.2022.2.2 9,559 2/7/2022
1.2022.2.1 2,477 2/6/2022
1.2022.1.5 4,660 1/31/2022
1.2022.1.4 6,741 1/19/2022
1.2022.1.3 3,428 1/17/2022
1.2022.1.2 2,732 1/16/2022
1.2021.10.2 23,451 10/6/2021
1.2021.4.4 34,596 4/1/2021
1.2020.12.3 21,656 12/15/2020
1.2020.12.2 2,379 12/14/2020
1.2020.11.2 10,292 11/13/2020
1.2020.11.1 3,016 11/11/2020
1.2020.9.1 13,600 9/21/2020
1.2020.7.3 12,861 7/22/2020
1.2020.6.2 10,406 6/7/2020
1.2020.5.7 6,335 5/23/2020
1.2019.12.1 24,381 12/2/2019
1.2019.9.1 17,912 9/10/2019
1.2019.4.1 24,554 4/8/2019
1.2019.3.7 8,819 3/15/2019
1.2019.3.6 4,214 3/12/2019
1.2018.12.5 15,916 12/18/2018
1.2018.12.2 3,996 12/14/2018
1.2018.12.1 2,491 12/14/2018
1.2018.8.2 17,989 8/30/2018
1.2018.6.1 14,481 6/15/2018
1.2018.4.2 16,333 4/6/2018
1.2018.2.2 15,984 2/12/2018
1.2018.2.1 7,327 2/1/2018
1.2018.1.3 14,088 1/5/2018
1.2017.10.4 31,707 10/25/2017
1.2017.10.3 6,134 10/24/2017
1.2017.8.1 35,922 8/3/2017
1.2017.6.119 38,121 6/13/2017
1.2017.2.117 58,650 2/9/2017
1.2016.12.115 38,469 12/13/2016
1.2016.7.113 32,503 7/7/2016
1.2016.6.111 9,538 6/23/2016
1.2016.5.109 8,714 5/26/2016
1.2016.5.107 6,303 5/12/2016
1.2016.4.106 4,755 4/28/2016

-- Updates --
1.2019.4.1 - Fixed #251 Wrong separator used for ODATA with multiple aggregates. Thanks to @filcole and @MarkMpn for the fix!
1.2019.3.7 - Fixed #250 Multiple condition operators and aggregate filters added to WebAPI support by @MarkMpn
1.2019.3.6 - Fixed #246,#247,#248 Crash when connected to CRM 2015 or earlier version
1.2019.3.4 - @MarkMpn continues to add improvements to WebAPI / Flow generator, bugfixes and support for aggregate queries

-- New features--
#123 Generate WebAPI queries by @MarkMpn
#241 Generate parameters for Flow List Records
#195 Convert from QueryExpression C# code to query by @BetimBeja

-- Bug fixes --
#237 Cancelling Close wipes the window.
#231 New - Paste XML does not update query builder

-- Other --
Removed XML validation against fetch.xsd as this is no longer up to date with the platform