Cinteros.Xrm.FetchXmlBuilder
1.2018.4.2
See the version list below for details.
dotnet add package Cinteros.Xrm.FetchXmlBuilder --version 1.2018.4.2
NuGet\Install-Package Cinteros.Xrm.FetchXmlBuilder -Version 1.2018.4.2
<PackageReference Include="Cinteros.Xrm.FetchXmlBuilder" Version="1.2018.4.2" />
paket add Cinteros.Xrm.FetchXmlBuilder --version 1.2018.4.2
#r "nuget: Cinteros.Xrm.FetchXmlBuilder, 1.2018.4.2"
// Install Cinteros.Xrm.FetchXmlBuilder as a Cake Addin #addin nuget:?package=Cinteros.Xrm.FetchXmlBuilder&version=1.2018.4.2 // Install Cinteros.Xrm.FetchXmlBuilder as a Cake Tool #tool nuget:?package=Cinteros.Xrm.FetchXmlBuilder&version=1.2018.4.2
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.
Product | Versions 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. |
-
- XrmToolBox (>= 1.2018.3.21)
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 | 30,031 | 10/5/2024 |
1.2024.9.3 | 15,407 | 9/4/2024 |
1.2024.4.1 | 33,151 | 4/27/2024 |
1.2023.11.1 | 43,327 | 11/12/2023 |
1.2023.8.2 | 27,663 | 8/21/2023 |
1.2023.8.1 | 6,073 | 8/13/2023 |
1.2023.2.2 | 40,673 | 2/14/2023 |
1.2022.11.2 | 20,400 | 11/23/2022 |
1.2022.8.1 | 20,398 | 8/20/2022 |
1.2022.5.1 | 31,603 | 5/29/2022 |
1.2022.4.1 | 12,398 | 4/24/2022 |
1.2022.3.1 | 15,601 | 3/1/2022 |
1.2022.2.2 | 9,571 | 2/7/2022 |
1.2022.2.1 | 2,489 | 2/6/2022 |
1.2022.1.5 | 4,672 | 1/31/2022 |
1.2022.1.4 | 6,753 | 1/19/2022 |
1.2022.1.3 | 3,440 | 1/17/2022 |
1.2022.1.2 | 2,746 | 1/16/2022 |
1.2021.10.2 | 23,464 | 10/6/2021 |
1.2021.4.4 | 34,610 | 4/1/2021 |
1.2020.12.3 | 21,679 | 12/15/2020 |
1.2020.12.2 | 2,390 | 12/14/2020 |
1.2020.11.2 | 10,306 | 11/13/2020 |
1.2020.11.1 | 3,047 | 11/11/2020 |
1.2020.9.1 | 13,616 | 9/21/2020 |
1.2020.7.3 | 12,873 | 7/22/2020 |
1.2020.6.2 | 10,417 | 6/7/2020 |
1.2020.5.7 | 6,345 | 5/23/2020 |
1.2019.12.1 | 24,394 | 12/2/2019 |
1.2019.9.1 | 17,923 | 9/10/2019 |
1.2019.4.1 | 24,564 | 4/8/2019 |
1.2019.3.7 | 8,831 | 3/15/2019 |
1.2019.3.6 | 4,225 | 3/12/2019 |
1.2018.12.5 | 15,928 | 12/18/2018 |
1.2018.12.2 | 4,007 | 12/14/2018 |
1.2018.12.1 | 2,502 | 12/14/2018 |
1.2018.8.2 | 18,031 | 8/30/2018 |
1.2018.6.1 | 14,497 | 6/15/2018 |
1.2018.4.2 | 16,349 | 4/6/2018 |
1.2018.2.2 | 16,007 | 2/12/2018 |
1.2018.2.1 | 7,343 | 2/1/2018 |
1.2018.1.3 | 14,105 | 1/5/2018 |
1.2017.10.4 | 31,724 | 10/25/2017 |
1.2017.10.3 | 6,150 | 10/24/2017 |
1.2017.8.1 | 35,938 | 8/3/2017 |
1.2017.6.119 | 38,155 | 6/13/2017 |
1.2017.2.117 | 58,683 | 2/9/2017 |
1.2016.12.115 | 38,498 | 12/13/2016 |
1.2016.7.113 | 32,535 | 7/7/2016 |
1.2016.6.111 | 9,558 | 6/23/2016 |
1.2016.5.109 | 8,731 | 5/26/2016 |
1.2016.5.107 | 6,321 | 5/12/2016 |
1.2016.4.106 | 4,774 | 4/28/2016 |
#186 Result Grid will now show columns in the order they were defined in the query
#199 Introduced option to allow opening uncustomizable views
#200 Fixed problem with query builder properties window being minimized
#202 Fixed SQL error with operators on, onorafter, onorbefore
#204 Fixed ugly error when composing queries unsupported for OData 2.0
* Minor UI fixes after XrmToolBox introduced docking layout
* OData error when including attributes from both main and linked entities