How to get those Record whose Activity Created or Change in last 24 hours in CRM

Question

I am creating CRM 2011 Fetch-xml Report and want to get those contact whose activity has been change or created in last 24 hours. how can I do that.

You should provide examples you have attempted at least or the specific parts of a fetch statement you don't understand! — Richard Dewhirst, Feb 07 '14 at 10:32

score 2 · Accepted Answer · edited Feb 01 '14 at 14:43

Start by retrieving all contacts, then inner join onto activities, then add a condition to only get those activities modified in the last 24 hours.

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">
  <entity name="contact">
    <attribute name="fullname" />
    <attribute name="telephone1" />
    <attribute name="contactid" />
    <order attribute="fullname" descending="false" />
    <link-entity name="activitypointer" from="regardingobjectid" to="contactid" alias="ac">
      <filter type="and">
        <condition attribute="modifiedon" operator="last-x-hours" value="24" />
      </filter>
    </link-entity>
  </entity>
</fetch>

How to get those Record whose Activity Created or Change in last 24 hours in CRM

1 Answers1