FetchXML Builder

Description

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.

Latest version release notes

-- New features--
#170 Save View As... Create a new personal view from existing
#210 Adding option to show dates with local time in result grid
Possible to review previous release notes in Welcome dialog

-- Bug fixes --
#129 Handle values for Fiscal conditions correctly
#205 Don't treat personal views as uncustomizable
#206 Distinct on countcolumn aggregate

-- Internal --
Rebranded with Jonas personal brand
Restructuring with assembly name Rappen.XTB.FXB.dll
Improved fetch schema load for XML validation
Implemented IAboutPlugin for generic access to About dialog

Versions

Version Release date Number of downloads Rating
1.2018.6.1 6/15/2018 10:40:29 AM 264 0.00
1.2018.4.2 4/6/2018 4:35:39 PM 13799 5.00
1.2018.2.2 2/12/2018 3:23:45 PM 13499 5.00
1.2018.2.1 2/1/2018 11:11:52 AM 4921 5.00
1.2018.1.3 1/5/2018 8:59:34 AM 11664 5.00
1.2018.1.2 1/4/2018 9:55:56 PM 110 0.00
1.2017.10.4 10/25/2017 2:42:30 PM 29294 5.00
1.2017.10.3 10/24/2017 1:27:42 PM 3749 0.00
1.2017.8.1 8/3/2017 10:37:02 AM 33582 5.00
1.2017.6.119 6/13/2017 10:52:21 AM 35737 0.00
1.2017.2.117 2/9/2017 3:12:31 PM 56113 0.00
1.2016.12.115 12/13/2016 11:12:21 PM 35550 0.00
1.2016.7.113 7/7/2016 2:17:10 PM 29843 0.00
1.2016.6.111 6/23/2016 9:55:29 AM 7030 0.00
1.2016.5.109 5/26/2016 2:18:20 PM 6158 0.00
1.2016.5.107 5/12/2016 3:13:01 PM 3621 0.00
1.2016.4.106 4/28/2016 3:16:08 PM 2453 0.00

Ratings

Latest version

No feedback yet. Add yours

Other versions

(Serjanya AE, )

(Scott Sewell, )
Essential.

(Roman Uvarov, )
GOOD

(Allan Varcoe, )

(Don Schiavone, )
Cannot imagine life without this tool!

(Scott Sewell, )
Using FetchXML Builder incrementally reduces my impact on global warming.

(Scott Sewell, )
Indispensable. - Absolutely essential for anyone going after XRM/CDS data.

(Njaka MISAHARISON, )

(Guillaume Goulfault, )

(Natraj Yegnaraman, )

(Josh Painter, )
Fantastic tool. I use it almost every day!

Related information

Author: Jonas Rapp Latest version: 1.2018.6.1 Released on: 06/15/2018 Nuget package Id: Cinteros.Xrm.FetchXmlBuilder Open Source: true Go to project web site Ratings (all versions) 5Average rating 11Number of ratings Downloads 264Latest version 287387All versions 16905.12Average per version