Hi All,
I am trying to write a report to find the difference between times of the case logged and the first email having regardingid as the caseid.
MS CRM Online
FetchXML SSRS report required.
I am not sure how this can be achieved as I tried a few fetchxml but don't seem to get anywhere.
<fetch version="1.0" mapping="logical" distinct="false" aggregate="true">
<entity name="incident">
<attribute name="title" groupby="true" alias="Title"/>
<attribute name="ticketnumber" groupby="true" alias="Ticket_number"/>
<attribute name="createdon" groupby="true" alias="create"/>
<attribute name="incidentid" groupby="true" alias="IncidentId" />
<filter type="and">
<condition attribute="createdon" operator="on-or-after" value="2013-05-01" />
</filter>
<link-entity name="email" from="regardingobjectid" to="incidentid" alias="ab">
<attribute name="actualend" alias='date_min' aggregate="min" />
</link-entity>
</entity>
</fetch>
This is failing on <attribute name="createdon" groupby="true" alias="create"/> line complaining that the dategrouping is invalid. i understand that this can't be done as grouping on date is not possible, but removing the
grouping on the created on date is not being liked as well.
Any other suggestions and approaches that can be taken to achieve this please??
Many Thanks.
