Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2022 Release Wave 1 PlanDynamics 365 release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
2022 release wave 1 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
I'm trying to dsiplay information from appointment and other data based on the regarding object (account, opportunity, lead...).
To make this work, I assume I shoud do a join with the medata entity and then display the needed fields . I looked for the metadata entity but it's not present.
On https://community.dynamics.com/365/f/dynamics-365-general-forum/402451/customer-guide-how-to-reduce-activitypointerbase, there's a nice query that counts records and shows if htey're appointment, etc. Perhaps that should be your base, as it uses ActivityPointer table
Maybe a join between Appointment and ActivityPointer table?
Thanks for the suggestion. It's not really what I'm looking for.
Finally, I wrote this code.
account.ctx_easynumber 'Account number',
account.address1_city 'Account city',
opportunity.name 'Opportunity name',
opportunity.ctx_mainopportunityreference 'Opportunity reference',
LEFT JOIN account
ON account.accountid = appointment.regardingobjectid
AND appointment.regardingobjecttypecode = 1
LEFT JOIN opportunity
ON opportunity.opportunityid = appointment.regardingobjectid
AND appointment.regardingobjecttypecode = 3
LEFT JOIN lead
ON lead.leadid = appointment.regardingobjectid
AND appointment.regardingobjecttypecode = 4
appointment.regardingobjectid IS NOT NULL
Business Applications communities