200
Hi,
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.
Thanks,
KR,
Hicham
Hi Daniel,
Thanks for the suggestion. It's not really what I'm looking for.
Finally, I wrote this code.
SELECT TOP 100 --regardingobjectid, --regardingobjectidname, regardingobjecttypecode, appointment.subject, --ActivityTypeCodeName, account.ctx_easynumber 'Account number', account.address1_city 'Account city', opportunity.name 'Opportunity name', opportunity.ctx_mainopportunityreference 'Opportunity reference', lead.firstname, lead.lastname FROM appointment 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 WHERE appointment.regardingobjectid IS NOT NULL
Greetings, Hicham
Hey Hicham.
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?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (