CRM FetchXMLBuilder ...

While developing applications (Plugins, Workflows, Service Portals) for CRM, it is a quite common requirement to build FetchXML or write search logic using QueryExpressions of CRM SDK API.

I found an excellent tool called Fetch XML Builder that helps you prepare FetchXML by building queries and joins using an intuitive user interface.

Let me tell you that there is a smarter way to extract FetchXML and this is how you can do it:

1. Open Advanced Find in CRM Build your search criteria in the UI (you can't get a sophisticated UI than this :-))
2. Save the query
3. Hit Find





4. View the source of the results page and search for the hidden field named "fetchXML".

Now, my attempt is not to outsmart the tool - Fetch XML Builder, but let me tell you how you can use this tool for some useful code :)

1. Launch Fetch XML Builder
2. Click "Import" -> "User Query" to import the query that we built in CRM





3. Now, let the tool generate code for you by clicking on "Create Code" -> "QueryExpression"

Let the effort that had gone towards building an intuitive UI for FetchXMLBuilder be appreciated :-)