Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM 2013 activities RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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