CODEWITHSUNDEEP
sql-serverdynamics-crm-2011crm
riaz.usmani
riaz.usmani

Reputation: 271

CRM 2011 Required Attendees field

I want to know that "Required Attendees" attribute of Appointment is in which database table in CRM 2011.

Thanks in advance.

Upvotes: 0

Views: 1018

Answers (1)

Zach Mast
Zach Mast

Reputation: 1718

This information is stored in the activitypartybase table. This table is a bridge between activities and "Parties" (contacts/accounts) that are related to the activity. The ParticipationTypeMask column tells you which type of relationship is represented. Required Attendees will have a ParticipationTypeMask value of 5. Note that I am referencing a 2013 system, but I believe this schema has not changed.

select * 
from activitypartybase 
where activityid = [The Guid of your Activity]
and ParticipationTypeMask = 5

Upvotes: 1

Related Questions