Microsoft Dynamics CRM (Archived)

Problem in FetchXML

(0) Share

Report

Posted on by Sayhaitokumar

7,042

Hello Guys,

I have problem in working with FetchXml (Integrating Asp.Net with MS CRM 2013 Online)

I want to retrieve record from Opportunity, I generate the Fetch-Xml using advanced (Xml contains link entities also)

Then in that Xml i added some attributes name for the link entity

When i run the code, it retrieves the data from crm, but the problem is (for Ex: opportunity is having only 4 records)

It shows different attribute count for all 4 records (i used debug to find the attribute)

Ex: First Record 15 attribute

Second Record 12 attribute

Third Record 18 attribute

Fourth Record 14 attribute

Total attribute included in the FetchXml is 18 attributes and some time it also shows the duplicate records

How to overcome those two problem? Give me an hint to solve this

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (2)

ScottDurow 21 on at

Like (0)

Report

Hi,

Could you post your fetchxml so we can take a look. It sounds like you are doing a join and so the records are duplicated as part of the join.

Was this reply helpful? Yes No
Aileen Gusni 44,524 on at

Like (0)

Report

Hi Saravana

Try to run the fetch xml tester then you can try to see the result and edit the source if needed

xrmtoolbox.codeplex.com

Thanks

Was this reply helpful? Yes No
Sayhaitokumar 7,042 on at

Like (0)

Report

Hello Scott,

Yes you are right I'm doing some join operation

Please have a look into my fetchxml

<fetch version='1.0' output-format='xml - platform' mapping='logical' distinct='true'>

<entity name = 'opportunity'>

<attribute name = 'name'/>

<attribute name = 'uts_billtoaccount'/>

<attribute name = 'uts_billtoaddress'/>

<attribute name = 'uts_shiptoaddress'/>

<attribute name = 'uts_salesperson'/>

<attribute name = 'uts_initialpaymentpercentage'/>

<attribute name = 'uts_productionpaymentpercentage'/>

<attribute name = 'uts_deliverypaymentpercentage'/>

<attribute name = 'uts_completionpaymentpercentage'/>

<attribute name = 'customerid'/>

<attribute name = 'estimatedvalue'/>

<attribute name = 'statuscode'/>

<attribute name = 'opportunityid' />

<order attribute = 'name' descending = 'false'/>

<filter type = 'and'>

<condition attribute = 'statecode' operator= 'eq' value = '1'/>

<filter type = 'or'>

<condition attribute = 'modifiedon' operator= 'not-null'/>

<condition attribute = 'modifiedon' operator= 'not-null'/>

</filter>

</filter>

<link-entity name='uts_opportunitylineitem' from='uts_parentopportunity' to='opportunityid' alias='ah'>

<attribute name = 'uts_quantity'/>

<attribute name = 'uts_totalprice'/>

<link-entity name='product' to='uts_product' from='productid' alias='ad'>

<attribute name = 'new_quickbookslineitemcode'/>

</link-entity>

</link-entity>

</entity>

</fetch>

Was this reply helpful? Yes No
Suggested answer

Sayhaitokumar 7,042 on at

Like (0)

Report

Hi Aileen,

In my system XrmToolBox is not working (I'm using windows 10)

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Hi saravan,

It seems that when you try to retrieve the records, some records doesn't contains value so

that's reason it doesn't returns that attribute of the record. so you have different no of

attribute for different record. Its a default behavior of CRM.

Was this reply helpful? Yes No
Suggested answer

ScottDurow 21 on at

Like (0)

Report

Hi,

With this join you will get the number of opportunities cross joined wiht the opportunitylineitem entity - so if you have 2 line items for each opportunity you will get 8 rows with the opportunity field duplicated twice. If there are null values, then the attribute will not be output in the xml response.

Hope this answers your question.

Was this reply helpful? Yes No
Verified answer

Sayhaitokumar 7,042 on at

Like (0)

Report

Hello Pankaj and scott,

Yes you people are right, just now i debugged and found the reason for the duplication and attribute count

Scott,

Is there any way to eliminate this duplication?

Was this reply helpful? Yes No
Suggested answer

ScottDurow 21 on at

Like (0)

Report

Hi - the very nature of cross joins means that you are requesting data from a child record and so the parent data will be duplicates for each child otherwise you wouldn't know which parent the child belongs to. When you render the data you can do some sort of tree/grouping.

Hope this answers your question.

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

Like (0)

Report

You can test FetchXML online http://msxrmtools.com

Was this reply helpful? Yes No