Microsoft Dynamics CRM (Archived)

CRM Dynamics - Views and FetchXml

(0) Share

Report

Posted on by Community Member

Hi,

I need to retrieve the underlying xml for a view for which i have the view-id.

Can i get a suggestion as to how this can be implemented.

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Yadnyesh Kuvalekar 4,102 on at

Like (2)

Report
Hi Prakash,

Using C# code, you can fetch view's XML as per below:

string fetchQuery = @"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'> <entity name='savedquery'> <attribute name='name' /> <attribute name='fetchxml' /> <attribute name='layoutxml' /> <attribute name='savedqueryid' /> <order attribute='name' descending='false' /> <filter type='and'> <condition attribute='savedqueryid' operator='eq' value='<your view id>' /> </filter> </entity> </fetch>"; EntityCollection eb = _OrgService.RetrieveMultiple(new FetchExpression(fetchQuery));

In FetchXml and LayoutXml fields, you can get Xml.

Also, FYI, you can use Download FetchXml option to download xml of a view from advance find window. Below is the screenshot.

Was this reply helpful? Yes No
Suggested answer

PhuocLV 347 on at

Like (2)

Report

You can use this managed solution: https://viewfetchxml.codeplex.com to easy view fetchxml in the advanced find.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Yadnyesh,

Thanks for your answer it works well. I have another query is it possible to nest fetchxml together like in this fetchxml I get the data :

<fetch version="1.0" mapping="logical" >

<entity name="jgs_leadcourse" >

<attribute name="jgs_name" />

<attribute name="createdon" />

<filter type="and" >

<condition attribute="statecode" operator="eq" value="0" />

</filter>

<attribute name="jgs_leadid" />

<attribute name="jgs_assignedtoid" />

<attribute name="jgs_assignedon" />

<attribute name="jgs_sourceid" />

<attribute name="jgs_ishighlyrated" />

<attribute name="jgs_leadcourseid" />

<attribute name="jgs_approvalstatus" />

<attribute name="jgs_approvaldiscount" />

<order attribute="createdon" descending="true" />

</entity>

</fetch>

and this is xml defining the data-definition on the visualization of a chart which i have fetched using visualization-id :

<datadefinition>

<fetchcollection>

<fetch mapping="logical" aggregate="true" >

<entity name="jgs_leadcourse" >

<attribute groupby="true" alias="_CRMAutoGen_groupby_column_Num_14" name="modifiedon" dategrouping="week" />

<attribute alias="_CRMAutoGen_aggregate_column_Num_15" name="jgs_name" aggregate="count" />

<attribute groupby="true" alias="_CRMAutoGen_groupby_column_Num_16" name="jgs_approvalstatus" />

</entity>

</fetch>

</fetchcollection>

<categorycollection>

<category alias="_CRMAutoGen_groupby_column_Num_14" >

<measurecollection>

<measure alias="_CRMAutoGen_aggregate_column_Num_15" />

</measurecollection>

</category>

</categorycollection>

</datadefinition>

i am trying to put them together, any suggestions.

Thanks.

Was this reply helpful? Yes No
Suggested answer

Yadnyesh Kuvalekar 4,102 on at

Like (0)

Report

Hi Prakash,

I have never worked on XML of chart's visualization. Though I research a bit about it, please check if below link if helpful to you.

crmchartguy.wordpress.com/.../crm-chart-xml

Thanks & Regards,

Yadnyesh Kuvalekar

Kindly tick verify answer if this resolves your query.

Was this reply helpful? Yes No