"An XrmToolBox plugin to create and run advanced FetchXML queries."

- Jonas Rapp, Sweden


The primary goal of the tool is to give developers, customizers and administrators of Microsoft Dynamics CRM an easy to use tool to create queries for views, reports and code. This includes the possibility to execute the queries to verify the results in various formats.

Information sources

Learn from the Introduction to FXB on my blog Jonas Rapp's CRM trenches.
Watch FXB on GitHub to recieve notifications on new releases and updates.
Discuss if you have feedback, questions or just want to talk FXB.
Submit issues for bugs and improvements in the issues section.

Project description

The tool will assist in three major areas:

1. Constructing FetchXML in ways that Advanced Find cannot

  • aggregates
  • outer joins
  • "has no"-queries
  • attributes from multi-level linked entities

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
  • 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 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.


Click OPEN CHAT in the bottom right corner of this web page to ask questions, give feedback, or simply to join the discussion!

Other XrmToolBox plugins from Jonas Rapp

Plugin Trace Viewer: ptv.xrmtoolbox.com
Auto Number Manager: anm.xrmtoolbox.com
Bulk Data Updater: github.com/rappen/BulkDataUpdater
Latebound Constants Generator: github.com/rappen/LateboundConstantsGenerator
Related Records Analyzer: github.com/rappen/RelatedRecordsAnalyzer

Flag Counter
Unique visitor count since 2015-02-19:

From the April 2016 release of XrmToolBox, download of plugins is handled in the built-in Plugin Store.
Run XrmToolBox and open the Plugin Store to get the latest version of FetchXML Builder!
Older versions can be downloaded by expanding the Downloads below.

Latest release   
Version Loading version...
Publish date Loading publish date...
Downloads (total)    + Loading download count...