Dataverse Metadata in FetchXML Builder

2021-10-122021-10-12 ~ Jonas Rapp ~ Leave a comment

I like smart tools.
I like smart code.
I don’t like smart tools and cool code – if I have to write it again.

One of the best XrmToolBox tools is the Metadata Browser – at least for me 😊

Continue reading →

Custom Translations – the Easy Way

2020-11-012020-11-01 ~ Jonas Rapp ~ 1 Comment

In many customer projects and products, I have built solutions for managing translations in Microsoft Dynamics 365 / CDS / CRM.
Sure, the metadata can be translated to show labels etc in the language of the user, but having a custom solution for translations ensures localized content for texts that are shown to the user from code or automation.

Continue reading →

FetchXML Builder July 2020 Release

2020-07-222020-09-10 ~ Jonas Rapp ~ 3 Comments

With the July 2020 release of FetchXML Builder for XrmToolBox the new Column Comparison feature of the FetchXML language is supported. Read more about all new features and fixes below.

Continue reading →

New website launched: fetchxmlbuilder.com

2020-07-202020-07-20 ~ Jonas Rapp ~ 1 Comment

Any tool worth its salt deserves a dedicated website. Six years after initial release, FetchXML Builder for XrmToolBox finally has its own home on the Internet.

Continue reading →

Querying date intervals in the Common Data Service

2020-06-012020-08-21 ~ Jonas Rapp ~ 10 Comments

Querying date intervals in Microsoft Common Data Service, Power Apps and Dynamics 365 is not always possible using Advanced Find nor is it as easy as working with plain SQL.

TL;DR – with FetchXML this is quite possible!

Continue reading →

Create view: Active Contacts in My State

2019-10-082020-09-10 ~ Jonas Rapp ~ 14 Comments

Microsoft Dynamics 365 Customer Engagement and Common Data Service offer us the querying language FetchXML to retrieve data. Since this is the language used for views saved in the system, we can use FetchXML Builder for XrmToolBox to alter the features of views beyond what is possible using platform features, without making them unsupported.

Continue reading →

FetchXML Builder and Friends at D365UG Virtual Summer Camp

2018-07-242020-08-21 ~ Jonas Rapp ~ 2 Comments

On August 7-9, the first ever Virtual Summer Camp for the Dynamics 365 platform will take place.

During this free event the D365UG offer some 30+ sessions with focus on Customer Service and Field/Project Service.

I will be doing one of a few cross vertical sessions, where I discuss and demonstrate some useful XrmToolBox tools that help customizers, administrators and users with information analysis and enhancing the capabilities of the system.

Below is a description of my session – enjoy and make sure you sign up! Click the link: D365UG Virtual Summer Camp

Continue reading “FetchXML Builder and Friends at D365UG Virtual Summer Camp” →

FetchXML Builder for Microsoft Dynamics 365/CRM got an extreme makeover

2018-01-052020-08-21 ~ Jonas Rapp ~ 7 Comments

The first release of FetchXML Builder for XrmToolBox in 2018 contains a major face-lift.

New year – new design! After more than three years since first release, the time has come to use all the feedback from issues on GitHub, comments on Twitter, and collected statistics to improve the UI. This article describes some of the major changes introduced with the first release of 2018.

Continue reading →

Create advanced views with FetchXML Builder

2015-05-302020-08-21 ~ Jonas Rapp ~ 4 Comments

My first article published on MSDynamicsWorld.com gives a detailed instruction on how to use FetchXML Builder to create advanced views in Microsoft Dynamics CRM – so advanced they are not possible to create using the CRM UI.