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
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
#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
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!
Author: Jonas Rapp, Innofactor SwedenLatest version: 1.2018.4.2Released on: 04/06/2018Nuget package Id: Cinteros.Xrm.FetchXmlBuilderOpen Source: trueGo to project web site Ratings (all versions)5Average rating9Number of ratings Downloads4578Latest version277647All versions17352.94Average per version