Microsoft Dynamics CRM (Archived)

Convert Fetch XML to SQL Query

(0) Share

Report

Posted on by Community Member

Is there a way to convert fetch xml to sql query?

- <fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">

- <entity name="orbus_graphicsproductionsheet">

- <filter type="and">

</filter>

- <link-entity name="salesorder" from="salesorderid" to="orbus_originalsalesorderid" alias="aa">

- <filter type="and">

</filter>

</link-entity>

</entity>

</fetch>

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Mathieu L 100 on at

Like (0)

Report

Hi Nicole,

You can use SQL Profiler to catch the SQL query.

- Launch SQL Profiler

- Execute your fetch XML query (Advanced find or view execution)

- Search a particular term in the profiler results to find the line

- SQL Profiler give you the exact query (with parameters)

Was this reply helpful? Yes No
Verified answer

Mahadeo Matre 17,021 on at

Like (1)

Report

Hi..

best option is to get SQL is to use SQL profiler, if you are using on-premise CRM.

your query will be look like

select orbus_graphicsproductionsheetid

, orbus_name

, createdon

, orbus_originalsalesorderid

, ehtc_shipdate

, orbus_taskstage

, orbus_stageaction

from orbus_graphicsproductionsheet

inner join salesorder

on orbus_graphicsproductionsheet.orbus_originalsalesorderid= salesorder.salesorderid

where

createdon >= DATEADD(yy, DATEDIFF(yy,0,getdate()), 0)

and ehtc_productionsheetid is not null

order by ehtc_shipdate desc, createdon asc

and here is more information on to get query..

inogic.com/.../use-sql-tracing-to-find-the-sql-query-generated-for-dynamics-crm-platform-operations-for-crm-on-premise

stackoverflow.com/.../convert-fetchxml-to-sql-temp-table

Hope this will work..

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi ,

Will it work for Dynamics CRM online?

Was this reply helpful? Yes No
suresh maurya 630 on at

Like (0)

Report

For testing of FetchXML, you can test here online http://msxrmtools.com

Was this reply helpful? Yes No