Sql query to fetch xml query for temporary table

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi All,

I am converting CRM 2013 reports to dynamics d365. As the SQL queries are not supported in d365 i need to write the fetch XML for it. One of the requirement is that :

there is one data-set which shows the value of years i.e Jan 2016 to Dec 2050 which is data-set for one of the parameter for my report. They have got this data-set by writing SQL query by creating temporary table in which they are retrieving this months.

Now since i need to convert this SQL query to fetch XML can anyone help me or tell if it is possible to create fetch XML query for creating temporary table and writing the code as above for retrieving the months as those i cannot fetch from CRM.

I tried and searched but not found any links for it.

Thanks

Categories:

Customization / Solutions / SDK and API

Other Functionality

Integration with Other Products

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Sql query to fetch xml query for temporary table

I created an entity for that in CRM and fetched the values

Thanks
LeoAlt 16,329 on at

Like (0)

Report

RE: Sql query to fetch xml query for temporary table

Hi partner,

Unfortunately, fetchxml does not support temporary table or subquery.

I suggest that you could change your logic and use "join" function in your sql code and fetchxml supports join function at the same time.

Here is a tool about transferring sql to fetchxml.http://www.sql2fetchxml.com/

Sorry that I didn't find other useful solutions for you.

Hope it helps.

Best Regards,

Leo