Hello All Experts,
i have created four dataset.
1.Activitytocustomentity
2.Appointmenttocustomentity
3.Tasktocustomentity
4.Phonecalltocustomentity
within the report 1.dataset and some fields as expression from 2 and 3 and 4th dataset i am using but there is only a single value getting populated along with first dataset .
how to avoid this.
Below is my fetchxml first 1.dataset. i.e (Activitytocustomentity)
<?xml version='1.0'?>
<fetch distinct='false' mapping='logical' output-format='xml-platform' version='1.0'>
<entity name='activitypointer'>
<attribute name='activitytypecode'/>
<attribute name='subject'/>
<attribute name='statecode'/>
<attribute name='prioritycode'/>
<attribute name='modifiedon'/>
<attribute name='activityid'/>
<attribute name='instancetypecode'/>
<attribute name='community'/>
<attribute name='scheduledstart'/>
<attribute name='sortdate'/>
<attribute name='slaid'/>
<attribute name='scheduleddurationminutes'/>
<attribute name='regardingobjectid'/>
<attribute name='stageid'/>
<attribute name='ownerid'/>
<attribute name='onholdtime'/>
<attribute name='modifiedonbehalfby'/>
<attribute name='modifiedby'/>
<attribute name='leftvoicemail'/>
<attribute name='lastonholdtime'/>
<attribute name='exchangerate'/>
<attribute name='scheduledend'/>
<attribute name='description'/>
<attribute name='deliveryprioritycode'/>
<attribute name='senton'/>
<attribute name='deliverylastattemptedon'/>
<attribute name='createdon'/>
<attribute name='transactioncurrencyid'/>
<attribute name='createdonbehalfby'/>
<attribute name='createdby'/>
<attribute name='actualstart'/>
<attribute name='actualend'/>
<attribute name='actualdurationminutes'/>
<attribute name='activityadditionalparams'/>
<order descending='false' attribute='modifiedon'/>
<link-entity name='new_customentity' alias='aa' to='regardingobjectid' from='new_customentityid'>
<attribute name='createdby'/>
<attribute name='ownerid'/>
<attribute name='new_uniqueid'/>
<filter type='and'>
<condition attribute='createdon' value='2017-01-01' operator='on-or-after'/>
<condition attribute='createdon' value='2017-12-31' operator='on-or-before'/>
</filter>
</link-entity>
</entity>
</fetch>
2. dataset fetchxml. i.e (Appointmenttocustomentity)
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="appointment">
<attribute name="subject" />
<attribute name="statecode" />
<attribute name="scheduledstart" />
<attribute name="scheduledend" />
<attribute name="createdby" />
<attribute name="regardingobjectid" />
<attribute name="activityid" />
<attribute name="instancetypecode" />
<attribute name="new_winplandimension" />
<attribute name="new_subcategorydescription" />
<attribute name="new_subcategoryid" />
<attribute name="subcategory" />
<attribute name="statuscode" />
<attribute name="sortdate" />
<attribute name="slaid" />
<attribute name="overriddencreatedon" />
<attribute name="stageid" />
<attribute name="processid" />
<attribute name="prioritycode" />
<attribute name="ownerid" />
<attribute name="onholdtime" />
<attribute name="modifiedon" />
<attribute name="modifiedonbehalfby" />
<attribute name="modifiedby" />
<attribute name="new_meetingminutesinternal" />
<attribute name="new_meetingminutesexternal" />
<attribute name="location" />
<attribute name="lastonholdtime" />
<attribute name="exchangerate" />
<attribute name="ap_engagementtype" />
<attribute name="scheduleddurationminutes" />
<attribute name="description" />
<attribute name="transactioncurrencyid" />
<attribute name="createdon" />
<attribute name="createdonbehalfby" />
<attribute name="category" />
<attribute name="new_categoryid" />
<attribute name="isalldayevent" />
<attribute name="activityadditionalparams" />
<attribute name="avanade_adhoc" />
<attribute name="actualstart" />
<attribute name="actualend" />
<attribute name="actualdurationminutes" />
<attribute name="activitytypecode" />
<attribute name="avanade_activityplanid" />
<order attribute="subject" descending="false" />
<link-entity name="new_customentity" from="new_customentityid" to="regardingobjectid" alias="ab">
<attribute name="ownerid" />
<attribute name="new_caseid" />
<filter type="and">
<condition attribute="createdon" operator="on-or-after" value="2017-01-01" />
<condition attribute="createdon" operator="on-or-before" value="2017-12-31" />
</filter>
</link-entity>
</entity>
</fetch>
likewise the other two has fetchxml
