Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / How to get data for in...
Microsoft Dynamics CRM (Archived)

How to get data for individual activities in advanced find with all columns.

(0) ShareShare
ReportReport
Posted on by EmployeeOcta

Hello All Experts,

I want to get all the columns of individual activities in advanced find.

I have one custom entity for which activities are enabled.

i am trying to go from activity as child and then custom entity as parent i advanced find so that i could get the custom entity columns as well.

i am selecting all the columns for activity but not able to get all the columns from the activity types like email, phone call, task etc.

can anyone help me in a single query i want to get all the columns from the different activity types.

*This post is locked for comments

  • EmployeeOcta Profile Picture
    EmployeeOcta on at
    RE: How to get data for individual activities in advanced find with all columns.

    Ok Pawell,

    i will open a new thread marking this as answer.

  • tw0sh3ds Profile Picture
    tw0sh3ds 5,600 on at
    RE: How to get data for individual activities in advanced find with all columns.

    You did get your answer for your original question, now you are asking different question (and looking for solution, not an answer). You should mark answers as verified, this is the whole purpose of having this forum.

  • EmployeeOcta Profile Picture
    EmployeeOcta on at
    RE: How to get data for individual activities in advanced find with all columns.

    Hello Nishkarsh,

    I din't get answer yet.

    Hello 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 duplication effect is seen .

    how to avoid this , can anyone help me in resolving this.

  • Suggested answer
    Nishkarsh Vaish Profile Picture
    Nishkarsh Vaish 335 on at
    RE: How to get data for individual activities in advanced find with all columns.

    Now can you get your answer or something else??

    If yes, mark as verified.

    Thanks

  • EmployeeOcta Profile Picture
    EmployeeOcta on at
    RE: How to get data for individual activities in advanced find with all columns.

    Thanks Nishkarsh for replying second point but untill first is completed second point can not be implemented, so that's why i asked both together.

  • Nishkarsh Vaish Profile Picture
    Nishkarsh Vaish 335 on at
    RE: How to get data for individual activities in advanced find with all columns.

    Report can be add it in some views for reports and also at specific entity view by clicking run report button.

    Marks As Answer If it helps you.

  • EmployeeOcta Profile Picture
    EmployeeOcta on at
    RE: How to get data for individual activities in advanced find with all columns.

    i think the below hierarchy is there.

                Appointment      Email      Phone Call    Task

                                          Activity

                                     Custom Entity

    and i don't think we can select all of the above in single advanced find query.

    Now for the same if we want to create SSRS report then what will be my fetchxml.

    where will i be able to display this report in crm.

    can anyone elaborate me more .

  • Verified answer
    Nishkarsh Vaish Profile Picture
    Nishkarsh Vaish 335 on at
    RE: How to get data for individual activities in advanced find with all columns.

    Hi

    As per my knowledge it is not possible in advance find of Dynamics 365 because in advance find we are able to select only parent entity columns. You can do it through SSRS reports.

    Refernce:

    https://community.dynamics.com/crm/f/117/t/197211

    You can also do it as Go to advance find and make a view of child entity and filter with parent entity.

    If it works then mark as verified.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans