locked
CRM 2013 activities RRS feed

  • Question

  • Hi All,

    I am trying to generate the reports for all activities(Task,Phonecall,Email)..

    in report i selected the entity name as activity..

    I am not able to see the fileds which has having task and Phone call entity?

    how can i bring in reports for this?


    Rammohan

    Wednesday, June 25, 2014 11:16 AM

All replies

  • Hi,


    Activitypointer contains only the fields that are common to all activity types. 
    To get the phonecall field you need to link activitypointer with other entities (phonecall/email) and then 
    you can get the attributes of related entity.

    write your query something like below-

    <fetch mapping="logical" count="50" version="1.0">
    <entity name="activitypointer">
    <attribute name="subject" />
    <link-entity name="phonecall" from="activityid" to="activityid" alias="phcall" link-type="outer">
    <attribute name="phonenumber" />
    </link-entity>
    </entity>
    </fetch>



    Wednesday, June 25, 2014 1:03 PM