What process converts any given FetchXML into sql?

(0) Share

Report

Posted on by stuart

2,080

We have two CRM organisations in different states (although similar) and when I run some simple FetchXML against both using the FetchXML tester I note that the underlying sql executed is different in structure. Does anyone know what object decides the format of the underlying sql executed? Is it a crm sproc, dll or other?

The reason for asking is that on one of the organisations (our live) the sql is invalid and shows itself as an error and on the other (test) it executes fine.

Thanks

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

Mahadeo Matre 17,021 on at

Like (0)

Report

RE: What process converts any given FetchXML into sql?

easy way to get SQL of FetchXML, by running SQL profiler.

When you execute fetchxml, CRM converts fetchxml to SQL and execute SQL queries.

you can get query from test and production and compare where it is failing.

NOTE: when you are running profiler on production server, it will reduce performance.
stuart 2,080 on at

Like (0)

Report

RE: What process converts any given FetchXML into sql?

Okay, thanks - I was hoping to avoid that route as there appears quite a hurdle before I can raise such a question. Hoping that someone can shed light on why the two different translations
Suggested answer

a33ik 84,323 Most Valuable Professional on at

Like (1)

Report

RE: What process converts any given FetchXML into sql?

Hello,

I'm afraid that to get an answer you will have to ask product team that has an access to CRM sourcecode.