Hi
I am setting custom fetchXML into a subgrid with setParameter.
Everything works fine and the records I am after are retured - but the export button to excel exports an empty file.
Is there any way to make the Export functionality work with the XML that i have passed?
var fetchXMLString =
'<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true"> ' +
'<entity name="campaignresponse"> ' +
'<attribute name="regardingobjectid" /> ' +
'<attribute name="subject" /> ' +
'<attribute name="activityid" /> ' +
'<order attribute="regardingobjectid" descending="false" /> ' +
'<order attribute="subject" descending="false" /> ' +
'<link-entity name="campaign" from="campaignid" to="regardingobjectid" visible="false" link-type="outer" alias="a_c5c66380f4824810b5eb58366de4ffb3"> ' +
'<attribute name="msa_eventtype" /> ' +
'<attribute name="actualstart" /> ' +
'</link-entity> ' +
'<link-entity name="activityparty" from="activityid" to="activityid" alias="ac"> ' +
'<link-entity name="account" from="accountid" to="partyid" alias="ad"> ' +
'<filter type="and"> ' +
'<condition attribute="accountid" operator="eq" value="' + crmForm.ObjectId + '"/> ' +
'</filter> ' +
'</link-entity> ' +
'</link-entity> ' +
'</entity> ' +
'</fetch>'
SubGridEventResponses.control.setParameter("fetchXML", getFetchXmlCampaigns());
SubGridEventResponses.control.refresh();
Thanks! Josh