Microsoft Dynamics CRM

{Quick Tip} How to convert your SQL expertise to Fetch XML expertise!

Sometimes, I feel that it is a tough nut to crack to write fetchxml for all sorts in CRM. With more implementations in CRM online and the need to do reporting using fetch xml reports it

becomes necessary to write the fetchxml.

So, I really appreciate the effort done by Kingswaysoft team in developing this online utility:

http://sql2fetchxml.com/

I gave some queries on this tool and found it quite useful.

Here are few examples:

Basic: A simple select statement on Filtered View Account entity:

clip_image001

Intermediate: A join between Account and contact entity:

clip_image002

Negative scenario: Though this is not realistic to convert below to FetchXML, I wanted to see the tool’s reaction to such a query. And it doesn’t break:

clip_image004

As you can see in the above screen, it doesn’t break and makes us understand the unsupported conditions.

Hope it helps and Happy CRMing!

Advertisements

3 thoughts on “{Quick Tip} How to convert your SQL expertise to Fetch XML expertise!”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s