Sign in

Microsoft.com

Microsoft

Remove From My Forums

how to convert Query to FetchXML query

Question
0

Sign in to vote
hi

I have a query I want to change it in fetchXML.

Select * from new_periodtotal Join product on product.pruductid = new_periodtotal.product Join new_program on new_program.product = new_periodtotal.product

Problem is there is no direct relationship with new_periodtotal and new_periodtotal both have relationship with Product. how I convert it in fetchXML query.
- Edited by Riaz Usmani Monday, January 13, 2014 11:17 AM
- Changed type HIMBAPModerator Monday, January 13, 2014 5:09 PM
Monday, January 13, 2014 10:39 AM

Answers

1

Sign in to vote
Try this. The "to" and "from" attributes will probably have to change based on the actual schema name of your lookup fields.

<fetch mapping="logical"> <entity name="new_periodtotal"> <link-entity name="product" to="productid" from="new_productid" link-type="inner"> <link-entity name="new_program" to="new_productid" from="new_productid" link-type="inner"> </link-entity> </link-entity> </entity> </fetch>

Blake Scarlavai - http://mscrmdev.blogspot.com/ - Sonoma Partners - http://www.sonomapartners.com/ - Follow @bscarlav
CRM 2011 JavaScript Model Generator - CRM 2011 Appender for log4net
- Proposed as answer by Blake ScarlavaiMVP Tuesday, January 14, 2014 5:39 AM
- Marked as answer by Riaz Usmani Thursday, April 14, 2016 11:58 PM
Tuesday, January 14, 2014 5:39 AM

All replies

0

Sign in to vote

Have a look at http://www.sql2fetchxml.com/ however if there is not direct relationship then you will have problem. You can create two data sets one for periodtotal and second for new_program and merge them in table by using Lookup function in expression

KG
My Dynamics CRM Blog: http://bovoweb.blogspot.com

Monday, January 13, 2014 10:48 AM
1

Sign in to vote
Try this. The "to" and "from" attributes will probably have to change based on the actual schema name of your lookup fields.

<fetch mapping="logical"> <entity name="new_periodtotal"> <link-entity name="product" to="productid" from="new_productid" link-type="inner"> <link-entity name="new_program" to="new_productid" from="new_productid" link-type="inner"> </link-entity> </link-entity> </entity> </fetch>

Blake Scarlavai - http://mscrmdev.blogspot.com/ - Sonoma Partners - http://www.sonomapartners.com/ - Follow @bscarlav
CRM 2011 JavaScript Model Generator - CRM 2011 Appender for log4net
- Proposed as answer by Blake ScarlavaiMVP Tuesday, January 14, 2014 5:39 AM
- Marked as answer by Riaz Usmani Thursday, April 14, 2016 11:58 PM
Tuesday, January 14, 2014 5:39 AM