Going Beyond Advanced Find, Views, and XRMToolbox: Using View Designer and FetchXML Builder with Dynamics CRM

by | Updated June 27, 2018 | Dynamics CRM

In part one of this topic, we discussed using the “FetchXML Tester” in the XRMToolbox to type in and test FetchXML, beyond what the Advanced Find in CRM is able to generate.  In this article, we will discuss a couple of other tools within the XRM toolbox that will let you create FetchXML apart from what the Advanced Find can do, and deploy this new query to a View in CRM.

We’ll discuss using View Designer and FetchXML Builder in Dynamics CRM.

View Designer

The View Designer allows you to connect to your CRM instance and download the current FetchXML that is utilized by a view within CRM.  In my example from Part 1, I needed to get a customer’s view called “All Opportunities Without an Open Activity” working properly.

NOTE:  It is important to remember that you will have to create the view you would like to customize in CRM before you use the “View Designer”.  In addition, it would not be advisable to update the out of the box views that come with CRM.

In the “View Designer” click Open.

Beyond Advanced Find

Select the entity associated with the view you wish to update.  This will populate the “View” pulldown allowing you to select the view you wish to update.

Beyond Advanced Find

After you select the view, you will see the XML of the grid associated with the view (columns, column sizes, etc).  Click OK on the Select View form and we will be able to start working with this View.

Some of the buttons on the “View Designer”:

  1. Live Preview – clicking this will fetch the data returned by the view and display it
  2. Select Columns – allows selection of the attributes in the FetchXML query and display the data as columns in your grid
  3. Edit XML – edit the grid associated with the view
  4. Edit Query – Edit the FetchXML associated with the view. This actually opens up a new tab with the “FetchXML Builder”
  5. Save – save your changes
  6. Publish – publish your view changes to your CRM org

In this example, we are going to want to update the FetchXML so we are going to click on Edit Query and add our FetchXML from Part 1.

Beyond Advanced Find

FetchXML Builder

The Edit Query button will open the “FetxhXML Builder” tab as you can see below.  “FetchXML Builder” is another tool that allows you to update or create FetchXML queries much like the “FetchXRM Tester” that we discussed in the first part of this series.

Beyond Advanced Find

This tool gives a few more options on how to create your query.  If you don’t like (or don’t feel comfortable) just typing in your FetchXML query like we did previously you can use the panel on the left to create or update your query.

Right-clicking on the various lines in the Query Builder panel gives you options on what you can add to your query.  For example, if you want to add another attribute to your query you can:

  1. Right click on the entity that contains the data you want to add
  2. Select Add
  3. Then select attribute

Beyond Advanced Find

4. In the Attribute Name field select the attribute to add

Beyond Advanced Find

5. Then click OK in the lower right-hand corner to see your attribute added to the FetchXML window.


  1. Right Click on the entity that contains the data you want to add
  2. Choose “Select Attributes”
  3. From the list shown, select the attributes that you want to add to the FetchXML.

Beyond Advanced Find

4. Click OK to see your selections added to the FetchXML

As you can see, the Query Builder has many options to help you with your fetch syntax and it is worth playing around with to see what it can do.

In our example, we already have the FetchXML that we want to use in the CRM view so instead of using the Query Builder pane, we are just going to paste our query into the “FetchXML Builder”.  To do this we are going to have to view the XML.  To do this click the “View” button and select FetchXML from the pulldown.

Beyond Advanced Find

This will open the FetchXML view.  All we have to do now is paste our query from Part 1 and click OK in the bottom right-hand corner.  The query builder will update to reflect the new XML.

Beyond Advanced Find

At this point, we can click “Execute” and test our query to make sure we get the results we are expecting.  Once we are satisfied with our query, we would like to get these changes back to the “View Designer”.  This is one button click away with the “Return FetchXML” button.

Beyond Advanced Find

This moves our query changes to the “View Designer” tab and sets our focus back in the “View Designer”.  You can click “Live Preview” to confirm your query changes.

Moving the query changes to your view in CRM is very easy at this point.

  1. Click Save
  2. Click Publish

This will move your FetchXML to the view that you have selected within your CRM org.  You now have a view utilizing an outer join and retrieving Opportunites without an open Activity.

Beyond Advanced Find

If you’d like to learn more about extending your CRM instance through these tools, let us know!

Related Posts

1 Comment

  1. Brian Hudson

    It’s worth noting that you cannot join with a custom entity and get attributes from it to display in the View. The error is: Could not find relationship for related entity field ab.abc_splitpercent specified in layoutxml.

Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events


03mar10:00 am10:30 amThe Modern Manufacturer - MRP vs. MPS – What, When and How

03mar2:00 pm2:30 pmLot Management Best Practices for Batch Manufacturers

10mar10:00 am10:30 amEnhancing the Customer Experience and Driving More Business with Dynamics 365 Customer Service

10mar2:00 pm2:30 pmThe Five Steps to Managing Sales Tax

11mar11:00 am12:00 pmConfab with Stoneridge - Livestream - Power Apps Component Framework Power Hour

17mar10:00 am10:30 amThe Modern Manufacturer: Pro Tips for your Finance Team

24mar10:00 am10:30 amUnlock the Potential of Digital Marketing with Dynamics 365 Marketing

25mar11:00 am12:00 pmConfab with Stoneridge - Livestream - The Four Keys to Choosing the Best ERP or CRM Solution

31mar10:00 am10:30 amThe Modern Manufacturer: Keys to Reporting Success

31mar01aprTraining Class: Financial Reporting W/Account Schedules for Dynamics 365 Business Central


31mar01aprTraining Class: Financial Reporting W/Account Schedules for Dynamics 365 Business Central

07apr10:00 am10:30 amBoost Seller Productivity and Close More Business with Dynamics 365 Sales

07apr2:00 pm2:30 pmEnsuring Quality for Batch Manufacturers

08apr11:00 am12:00 pmJumping into the Deep End of the Data Lake

14apr10:00 am10:30 amThe Modern Manufacturer: Cost Accounting in D365

22apr11:00 am12:00 pmMoving from Manual to Automated with Strategic Automation Strategies

28apr10:00 am10:30 amThe Modern Manufacturer: Best Practices for Inventory Turn

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!