Class AppointmentTableInfo
Table 'appointment': Tasks, appointments, followups, phone calls; and documents (document_id != 0). An appointment always has a corresponding record in VisibleFor specifying who may see this.
Inheritance
AppointmentTableInfo
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("appointment")]
public class AppointmentTableInfo : TableInfo, ICloneable
Fields
DictionaryTableName
Conceptual name of table Appointment in the database dictionary: appointment
Declaration
public const string DictionaryTableName = "appointment"
Field Value
Properties
ActiveDate
Field 'activeDate' in table 'appointment': Dictionary type DateTime, .NET type: DateTime
The date to be used for searching & showing
Declaration
public DateTimeFieldInfo ActiveDate { get; }
Property Value
ActiveLinks
Field 'activeLinks' in table 'appointment': Dictionary type UInt, .NET type: uint
Number of active links to documents, other appointments, and such
Declaration
public FieldInfo ActiveLinks { get; }
Property Value
AgendaTextId
Field 'agenda_text_id' in table 'appointment': Dictionary type FK, target: Text, .NET type: int
ID of record containing agenda text
Declaration
public Int32FieldInfo AgendaTextId { get; }
Property Value
AgendaTextId_InnerJoin_Text
Generated join from the foreign key AgendaTextId in this table, to its target table TextTableInfo.
Declaration
public TargetedInnerJoin<TextTableInfo> AgendaTextId_InnerJoin_Text { get; }
Property Value
Alarm
Field 'alarm' in table 'appointment': Dictionary type UShort, .NET type: short
Alarm leadtime, the alarm flag has moved to hasAlarm
Declaration
public UInt16FieldInfo Alarm { get; }
Property Value
AlldayEvent
Field 'alldayEvent' in table 'appointment': Dictionary type Enum, .NET type: AllDayEvent
Is this an all day event: 0 = No, 1 = Yes
Declaration
public AllDayEventFieldInfo AlldayEvent { get; }
Property Value
AppointmentId
Field 'appointment_id' in table 'appointment': Dictionary type PK, .NET type: int
Primary key
Declaration
public Int32FieldInfo AppointmentId { get; }
Property Value
AssignedBy
Field 'assignedBy' in table 'appointment': Dictionary type FK, target: Associate, .NET type: int
Who (last) assigned this appointment to associate_id?
Declaration
public Int32FieldInfo AssignedBy { get; }
Property Value
AssignedBy_InnerJoin_Associate
Generated join from the foreign key AssignedBy in this table, to its target table AssociateTableInfo.
Declaration
public TargetedInnerJoin<AssociateTableInfo> AssignedBy_InnerJoin_Associate { get; }
Property Value
AssociateId
Field 'associate_id' in table 'appointment': Dictionary type FK, target: Associate, .NET type: int
ID of associate whose diary the appointment is in, REQUIRED
Declaration
public Int32FieldInfo AssociateId { get; }
Property Value
AssociateId_InnerJoin_Associate
Generated join from the foreign key AssociateId in this table, to its target table AssociateTableInfo.
Declaration
public TargetedInnerJoin<AssociateTableInfo> AssociateId_InnerJoin_Associate { get; }
Property Value
CautionWarning
Field 'cautionWarning' in table 'appointment': Dictionary type Enum, .NET type: AppointmentCautionWarning
Status field to indicate appointments that have some sort of problem
Declaration
public AppointmentCautionWarningFieldInfo CautionWarning { get; }
Property Value
CentralserviceVideomeetId
Field 'centralservice_videomeet_id' in table 'appointment': Dictionary type String[101], .NET type: string
GUID for video meeting in central services – this is set when we create meetings from SuperOffice. It is blank for incoming meetings created from inbox.
Declaration
public StringFieldInfo CentralserviceVideomeetId { get; }
Property Value
ColorIndex
Field 'color_index' in table 'appointment': Dictionary type UShort, .NET type: short
Appointment colour, used only in Japanese versions. Western versions take colour from Task
Declaration
public UInt16FieldInfo ColorIndex { get; }
Property Value
Field 'contact_id' in table 'appointment': Dictionary type FK, target: Contact, .NET type: int
Contact ID of owning contact, may be 0
Declaration
public Int32FieldInfo ContactId { get; }
Property Value
Generated join from the foreign key ContactId in this table, to its target table ContactTableInfo.
Declaration
public TargetedInnerJoin<ContactTableInfo> ContactId_InnerJoin_Contact { get; }
Property Value
CreatedByWorkflowId
Field 'created_by_workflow_id' in table 'appointment': Dictionary type FK, target: Workflow, .NET type: int
The workflow this follow-up was created by
Declaration
public Int32FieldInfo CreatedByWorkflowId { get; }
Property Value
CreatedByWorkflowId_InnerJoin_Workflow
Generated join from the foreign key CreatedByWorkflowId in this table, to its target table WorkflowTableInfo.
Declaration
public TargetedInnerJoin<WorkflowTableInfo> CreatedByWorkflowId_InnerJoin_Workflow { get; }
Property Value
Definition
Definition of the table as described in the deployed runtime dictionary
Declaration
public override SoTable Definition { get; }
Property Value
Overrides
DictionaryTableNumber
Table number for table Appointment in the database dictionary; potentially changes between databases, but
always the same over the lifetime of any single database
Declaration
public int DictionaryTableNumber { get; }
Property Value
DoBy
Field 'do_by' in table 'appointment': Dictionary type DateTime, .NET type: DateTime
date + start time planned
Declaration
public DateTimeFieldInfo DoBy { get; }
Property Value
DocumentId
Field 'document_id' in table 'appointment': Dictionary type FK, target: Document, .NET type: int
Points to document record; 0 for non-document appointments!
Declaration
public Int32FieldInfo DocumentId { get; }
Property Value
DocumentId_InnerJoin_Document
Generated join from the foreign key DocumentId in this table, to its target table DocumentTableInfo.
Declaration
public TargetedInnerJoin<DocumentTableInfo> DocumentId_InnerJoin_Document { get; }
Property Value
Done
Field 'done' in table 'appointment': Dictionary type DateTime, .NET type: DateTime
date + start time this task was done
Declaration
public DateTimeFieldInfo Done { get; }
Property Value
EmailId
Field 'emailId' in table 'appointment': Dictionary type FK, target: Email, .NET type: int
If invitation and status changes should be mailed, this is the ID of the email address used
Declaration
public Int32FieldInfo EmailId { get; }
Property Value
EmailId_InnerJoin_Email
Generated join from the foreign key EmailId in this table, to its target table EmailTableInfo.
Declaration
public TargetedInnerJoin<EmailTableInfo> EmailId_InnerJoin_Email { get; }
Property Value
EndDate
Field 'endDate' in table 'appointment': Dictionary type DateTime, .NET type: DateTime
Date + end time planned
Declaration
public DateTimeFieldInfo EndDate { get; }
Property Value
FreeBusy
Field 'freeBusy' in table 'appointment': Dictionary type Enum, .NET type: FreeBusy
What kind of time is this: 0 = Busy, 1 = Free
Declaration
public FreeBusyFieldInfo FreeBusy { get; }
Property Value
GroupIdx
Field 'group_idx' in table 'appointment': Dictionary type FK, target: UserGroup, .NET type: int
Group of owning associate at the time tha ppnt was created
Declaration
public Int32FieldInfo GroupIdx { get; }
Property Value
GroupIdx_InnerJoin_UserGroup
Generated join from the foreign key GroupIdx in this table, to its target table UserGroupTableInfo.
Declaration
public TargetedInnerJoin<UserGroupTableInfo> GroupIdx_InnerJoin_UserGroup { get; }
Property Value
HasAlarm
Field 'hasAlarm' in table 'appointment': Dictionary type Bool, .NET type: short
Does this appointment have an alarm
Declaration
public UInt16FieldInfo HasAlarm { get; }
Property Value
InternalNotesTextId
Field 'internal_notes_text_id' in table 'appointment': Dictionary type FK, target: Text, .NET type: int
ID of record containing internal notes text
Declaration
public Int32FieldInfo InternalNotesTextId { get; }
Property Value
InternalNotesTextId_InnerJoin_Text
Generated join from the foreign key InternalNotesTextId in this table, to its target table TextTableInfo.
Declaration
public TargetedInnerJoin<TextTableInfo> InternalNotesTextId_InnerJoin_Text { get; }
Property Value
InvitedPersonId
Field 'invitedPersonId' in table 'appointment': Dictionary type FK, target: Person, .NET type: int
Valid when mother_id != 0 && mother_id != id
Declaration
public Int32FieldInfo InvitedPersonId { get; }
Property Value
InvitedPersonId_InnerJoin_Person
Generated join from the foreign key InvitedPersonId in this table, to its target table PersonTableInfo.
Declaration
public TargetedInnerJoin<PersonTableInfo> InvitedPersonId_InnerJoin_Person { get; }
Property Value
IsMilestone
Field 'isMilestone' in table 'appointment': Dictionary type Bool, .NET type: short
Is this appointment a milestone?
Declaration
public UInt16FieldInfo IsMilestone { get; }
Property Value
JoinVideomeetUrl
Field 'join_videomeet_url' in table 'appointment': Dictionary type String[2001], .NET type: string
Blank when not a video meeting. Filled with Join Meeting URL when created.
Declaration
public StringFieldInfo JoinVideomeetUrl { get; }
Property Value
LagTime
Field 'lagTime' in table 'appointment': Dictionary type UShort, .NET type: short
as leadtime, but after the end - time blocked for travel etc.
Declaration
public UInt16FieldInfo LagTime { get; }
Property Value
Leadtime
Field 'leadtime' in table 'appointment': Dictionary type UShort, .NET type: short
Time blocked (minutes) BEFORE starttime
Declaration
public UInt16FieldInfo Leadtime { get; }
Property Value
LeftOuterJoin_Document_AppointmentId
Generated left outer join from the primary key AppointmentId on this table, to Document.AppointmentId.
Declaration
public TargetedLeftOuterJoin<DocumentTableInfo> LeftOuterJoin_Document_AppointmentId { get; }
Property Value
LeftOuterJoin_EmailItem_AppointmentId
Generated left outer join from the primary key AppointmentId on this table, to EmailItem.AppointmentId.
Declaration
public TargetedLeftOuterJoin<EmailItemTableInfo> LeftOuterJoin_EmailItem_AppointmentId { get; }
Property Value
LeftOuterJoin_Email_AppointmentId
Generated left outer join from the primary key AppointmentId on this table, to Email.AppointmentId.
Declaration
public TargetedLeftOuterJoin<EmailTableInfo> LeftOuterJoin_Email_AppointmentId { get; }
Property Value
LeftOuterJoin_Invitation_AppointmentId
Generated left outer join from the primary key AppointmentId on this table, to Invitation.AppointmentId.
Declaration
public TargetedLeftOuterJoin<InvitationTableInfo> LeftOuterJoin_Invitation_AppointmentId { get; }
Property Value
LeftOuterJoin_Project_NmdAppointmentId
Generated left outer join from the primary key AppointmentId on this table, to Project.NmdAppointmentId.
Declaration
public TargetedLeftOuterJoin<ProjectTableInfo> LeftOuterJoin_Project_NmdAppointmentId { get; }
Property Value
LeftOuterJoin_QuoteVersion_FollowupId
Generated left outer join from the primary key AppointmentId on this table, to QuoteVersion.FollowupId.
Declaration
public TargetedLeftOuterJoin<QuoteVersionTableInfo> LeftOuterJoin_QuoteVersion_FollowupId { get; }
Property Value
LeftOuterJoin_SaleHist_AppointmentId
Generated left outer join from the primary key AppointmentId on this table, to SaleHist.AppointmentId.
Declaration
public TargetedLeftOuterJoin<SaleHistTableInfo> LeftOuterJoin_SaleHist_AppointmentId { get; }
Property Value
LeftOuterJoin_SaleHist_NddAppointmentId
Generated left outer join from the primary key AppointmentId on this table, to SaleHist.NddAppointmentId.
Declaration
public TargetedLeftOuterJoin<SaleHistTableInfo> LeftOuterJoin_SaleHist_NddAppointmentId { get; }
Property Value
LeftOuterJoin_Sale_AppointmentId
Generated left outer join from the primary key AppointmentId on this table, to Sale.AppointmentId.
Declaration
public TargetedLeftOuterJoin<SaleTableInfo> LeftOuterJoin_Sale_AppointmentId { get; }
Property Value
LeftOuterJoin_Sale_NddAppointmentId
Generated left outer join from the primary key AppointmentId on this table, to Sale.NddAppointmentId.
Declaration
public TargetedLeftOuterJoin<SaleTableInfo> LeftOuterJoin_Sale_NddAppointmentId { get; }
Property Value
LeftOuterJoin_VisibleFor_AppointmentId
Generated left outer join from the primary key AppointmentId on this table, to VisibleFor.AppointmentId.
Declaration
public TargetedLeftOuterJoin<VisibleForTableInfo> LeftOuterJoin_VisibleFor_AppointmentId { get; }
Property Value
Location
Field 'location' in table 'appointment': Dictionary type String[255], .NET type: string
Location for appointment, defaulted from invited resource of type place and other rules, but you can write anything you want here
Declaration
public StringFieldInfo Location { get; }
Property Value
ModifiedAppointmentFields
Field 'modified_appointment_fields' in table 'appointment': Dictionary type Enum, .NET type: ModifiedAppointmentFields
Which important fields of an appointment have been changed. Used by notifications.
Declaration
public ModifiedAppointmentFieldsFieldInfo ModifiedAppointmentFields { get; }
Property Value
MotherAssociateId
Field 'mother_associate_id' in table 'appointment': Dictionary type FK, target: Associate, .NET type: int
Associate/owner of the mother appointment
Declaration
public Int32FieldInfo MotherAssociateId { get; }
Property Value
MotherAssociateId_InnerJoin_Associate
Generated join from the foreign key MotherAssociateId in this table, to its target table AssociateTableInfo.
Declaration
public TargetedInnerJoin<AssociateTableInfo> MotherAssociateId_InnerJoin_Associate { get; }
Property Value
MotherId
Field 'mother_id' in table 'appointment': Dictionary type FK, target: Appointment, .NET type: int
ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
Declaration
public Int32FieldInfo MotherId { get; }
Property Value
MotherId_InnerJoin_Appointment
Generated join from the foreign key MotherId in this table, to its target table AppointmentTableInfo.
Declaration
public TargetedInnerJoin<AppointmentTableInfo> MotherId_InnerJoin_Appointment { get; }
Property Value
OriginalStartDate
Field 'original_start_date' in table 'appointment': Dictionary type DateTime, .NET type: DateTime
The original start date for an appointment in a recurring series
Declaration
public DateTimeFieldInfo OriginalStartDate { get; }
Property Value
OwnedExternally
Field 'owned_externally' in table 'appointment': Dictionary type Enum, .NET type: AppointmentExternalOwner
Set if an external system owns this appointment.
Declaration
public AppointmentExternalOwnerFieldInfo OwnedExternally { get; }
Property Value
PersonId
Field 'person_id' in table 'appointment': Dictionary type FK, target: Person, .NET type: int
Person ID of person the appointment is with, may be 0
Declaration
public Int32FieldInfo PersonId { get; }
Property Value
PersonId_InnerJoin_Person
Generated join from the foreign key PersonId in this table, to its target table PersonTableInfo.
Declaration
public TargetedInnerJoin<PersonTableInfo> PersonId_InnerJoin_Person { get; }
Property Value
PreferredTZLocation
Field 'preferredTZLocation' in table 'appointment': Dictionary type FK, target: TZLocation, .NET type: int
Preferred timezone location to use when displaying/editing this appointment
Declaration
public Int32FieldInfo PreferredTZLocation { get; }
Property Value
PreferredTZLocation_InnerJoin_TZLocation
Generated join from the foreign key PreferredTZLocation in this table, to its target table TZLocationTableInfo.
Declaration
public TargetedInnerJoin<TZLocationTableInfo> PreferredTZLocation_InnerJoin_TZLocation { get; }
Property Value
PriorityIdx
Field 'priority_idx' in table 'appointment': Dictionary type FK, target: Priority, .NET type: int
Link to priority list
Declaration
public Int32FieldInfo PriorityIdx { get; }
Property Value
PriorityIdx_InnerJoin_Priority
Generated join from the foreign key PriorityIdx in this table, to its target table PriorityTableInfo.
Declaration
public TargetedInnerJoin<PriorityTableInfo> PriorityIdx_InnerJoin_Priority { get; }
Property Value
Private
Field 'private' in table 'appointment': Dictionary type Enum, .NET type: AppointmentPrivate
Obsolete, but still maintained field for appointment privacy; denormalization of visiblefor status
Declaration
public AppointmentPrivateFieldInfo Private { get; }
Property Value
ProjectId
Field 'project_id' in table 'appointment': Dictionary type FK, target: Project, .NET type: int
ID of project referred to, may be 0
Declaration
public Int32FieldInfo ProjectId { get; }
Property Value
ProjectId_InnerJoin_Project
Generated join from the foreign key ProjectId in this table, to its target table ProjectTableInfo.
Declaration
public TargetedInnerJoin<ProjectTableInfo> ProjectId_InnerJoin_Project { get; }
Property Value
RecurrenceRuleId
Field 'recurrenceRuleId' in table 'appointment': Dictionary type FK, target: RecurrenceRule, .NET type: int
Pointer to recurrence rule, for recurring appointments, otherwise 0
Declaration
public Int32FieldInfo RecurrenceRuleId { get; }
Property Value
RecurrenceRuleId_InnerJoin_RecurrenceRule
Declaration
public TargetedInnerJoin<RecurrenceRuleTableInfo> RecurrenceRuleId_InnerJoin_RecurrenceRule { get; }
Property Value
Registered
Field 'registered' in table 'appointment': Dictionary type UtcDateTime, .NET type: DateTime
Registered date
Declaration
public DateTimeFieldInfo Registered { get; }
Property Value
RegisteredAssociateId
Field 'registered_associate_id' in table 'appointment': Dictionary type FK, target: Associate, .NET type: int
Registered by whom
Declaration
public Int32FieldInfo RegisteredAssociateId { get; }
Property Value
RegisteredAssociateId_InnerJoin_Associate
Generated join from the foreign key RegisteredAssociateId in this table, to its target table AssociateTableInfo.
Declaration
public TargetedInnerJoin<AssociateTableInfo> RegisteredAssociateId_InnerJoin_Associate { get; }
Property Value
RejectCounter
Field 'rejectCounter' in table 'appointment': Dictionary type UShort, .NET type: short
How many invitees have rejected this appointment
Declaration
public UInt16FieldInfo RejectCounter { get; }
Property Value
RejectReason
Field 'rejectReason' in table 'appointment': Dictionary type String[255], .NET type: string
Why was this booking or assignment rejected, the RejectReason list is a source of suggestions but you can write anything here
Declaration
public StringFieldInfo RejectReason { get; }
Property Value
RuntimeDefinition
Definition of the table as described in the deployed runtime dictionary
Declaration
[Obsolete("Use instance property Definition or static member DictionaryTableNumber", true)]
public static SoTable RuntimeDefinition { get; }
Property Value
SaleId
Field 'sale_id' in table 'appointment': Dictionary type FK, target: Sale, .NET type: int
Owning sale, if any (may be 0)
Declaration
public Int32FieldInfo SaleId { get; }
Property Value
SaleId_InnerJoin_Sale
Generated join from the foreign key SaleId in this table, to its target table SaleTableInfo.
Declaration
public TargetedInnerJoin<SaleTableInfo> SaleId_InnerJoin_Sale { get; }
Property Value
SendEmail
Field 'SendEmail' in table 'appointment': Dictionary type Bool, .NET type: short
Send invitation and appointment changes by e-mail to this participant.
Declaration
public UInt16FieldInfo SendEmail { get; }
Property Value
Source
Field 'source' in table 'appointment': Dictionary type UShort, .NET type: short
For future integration use; source of record
Declaration
public UInt16FieldInfo Source { get; }
Property Value
Status
Field 'status' in table 'appointment': Dictionary type Enum, .NET type: AppointmentStatus
status=done,started, not started, hidden
Declaration
public AppointmentStatusFieldInfo Status { get; }
Property Value
SuggestedAppointmentId
Field 'suggestedAppointmentId' in table 'appointment': Dictionary type FK, target: SuggestedAppointment, .NET type: int
Suggested guide item that this appointment is an instance of (Note: NOT VALID for document-type appointments, they have their own link)
Declaration
public Int32FieldInfo SuggestedAppointmentId { get; }
Property Value
SuggestedAppointmentId_InnerJoin_SuggestedAppointment
Declaration
public TargetedInnerJoin<SuggestedAppointmentTableInfo> SuggestedAppointmentId_InnerJoin_SuggestedAppointment { get; }
Property Value
SuggestedDocumentId
Field 'suggestedDocumentId' in table 'appointment': Dictionary type FK, target: SuggestedDocument, .NET type: int
Suggested guide item that this document is an instance of (Note: NOT valid for appointments, they have their own link)
Declaration
public Int32FieldInfo SuggestedDocumentId { get; }
Property Value
SuggestedDocumentId_InnerJoin_SuggestedDocument
Declaration
public TargetedInnerJoin<SuggestedDocumentTableInfo> SuggestedDocumentId_InnerJoin_SuggestedDocument { get; }
Property Value
TaskIdx
Field 'task_idx' in table 'appointment': Dictionary type FK, target: Task, .NET type: int
Link to Task list, OR to DocTmpl list, if this is a document
Declaration
public Int32FieldInfo TaskIdx { get; }
Property Value
TaskIdx_InnerJoin_Task
Generated join from the foreign key TaskIdx in this table, to its target table TaskTableInfo.
Declaration
public TargetedInnerJoin<TaskTableInfo> TaskIdx_InnerJoin_Task { get; }
Property Value
TextId
Field 'text_id' in table 'appointment': Dictionary type FK, target: Text, .NET type: int
ID of record containing appointment text
Declaration
public Int32FieldInfo TextId { get; }
Property Value
TextId_InnerJoin_Text
Generated join from the foreign key TextId in this table, to its target table TextTableInfo.
Declaration
public TargetedInnerJoin<TextTableInfo> TextId_InnerJoin_Text { get; }
Property Value
Type
Field 'type' in table 'appointment': Dictionary type Enum, .NET type: AppointmentType
where=no start time,note,docin, docout
Declaration
public AppointmentTypeFieldInfo Type { get; }
Property Value
Updated
Field 'updated' in table 'appointment': Dictionary type UtcDateTime, .NET type: DateTime
Updated date
Declaration
public DateTimeFieldInfo Updated { get; }
Property Value
UpdatedAssociateId
Field 'updated_associate_id' in table 'appointment': Dictionary type FK, target: Associate, .NET type: int
Updated by who
Declaration
public Int32FieldInfo UpdatedAssociateId { get; }
Property Value
UpdatedAssociateId_InnerJoin_Associate
Generated join from the foreign key UpdatedAssociateId in this table, to its target table AssociateTableInfo.
Declaration
public TargetedInnerJoin<AssociateTableInfo> UpdatedAssociateId_InnerJoin_Associate { get; }
Property Value
UpdatedCount
Field 'updatedCount' in table 'appointment': Dictionary type UShort, .NET type: short
Number of updates made to this record
Declaration
public UInt16FieldInfo UpdatedCount { get; }
Property Value
Userdef2Id
Field 'userdef2_id' in table 'appointment': Dictionary type FK, target: UDAppntLarge, .NET type: int
User defined table record 2 (for future use)
Declaration
public Int32FieldInfo Userdef2Id { get; }
Property Value
Userdef2Id_InnerJoin_UDAppntLarge
Declaration
public TargetedInnerJoin<UDAppntLargeTableInfo> Userdef2Id_InnerJoin_UDAppntLarge { get; }
Property Value
UserdefId
Field 'userdef_id' in table 'appointment': Dictionary type FK, target: UDAppntSmall, .NET type: int
User defined table record 1 (for future use)
Declaration
public Int32FieldInfo UserdefId { get; }
Property Value
UserdefId_InnerJoin_UDAppntSmall
Declaration
public TargetedInnerJoin<UDAppntSmallTableInfo> UserdefId_InnerJoin_UDAppntSmall { get; }
Property Value
Methods
IdxAssociateId(int)
Shortcut method for looking up using the database index AssociateId, which spans the following fields:
| Field | Description |
|---|
| AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
Declaration
public Restriction IdxAssociateId(int associateId)
Parameters
| Type |
Name |
Description |
| int |
associateId |
|
Returns
IdxAssociateIdActiveDate(int, DateTime)
Shortcut method for looking up using the database index AssociateIdActiveDate, which spans the following fields:
| Field | Description |
|---|
| AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
| ActiveDate | The date to be used for searching & showing |
Declaration
public Restriction IdxAssociateIdActiveDate(int associateId, DateTime activeDate)
Parameters
| Type |
Name |
Description |
| int |
associateId |
|
| DateTime |
activeDate |
|
Returns
IdxAssociateIdActiveDateMotherId(int, DateTime, int)
Shortcut method for looking up using the database index AssociateIdActiveDateMotherId, which spans the following fields:
| Field | Description |
|---|
| AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
| ActiveDate | The date to be used for searching & showing |
| MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
Declaration
public Restriction IdxAssociateIdActiveDateMotherId(int associateId, DateTime activeDate, int motherId)
Parameters
| Type |
Name |
Description |
| int |
associateId |
|
| DateTime |
activeDate |
|
| int |
motherId |
|
Returns
IdxAssociateIdStatus(int, AppointmentStatus)
Shortcut method for looking up using the database index AssociateIdStatus, which spans the following fields:
| Field | Description |
|---|
| AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
| Status | status=done,started, not started, hidden |
Declaration
public Restriction IdxAssociateIdStatus(int associateId, AppointmentStatus status)
Parameters
Returns
IdxAssociateIdStatusDoBy(int, AppointmentStatus, DateTime)
Shortcut method for looking up using the database index AssociateIdStatusDoBy, which spans the following fields:
| Field | Description |
|---|
| AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
| Status | status=done,started, not started, hidden |
| DoBy | date + start time planned |
Declaration
public Restriction IdxAssociateIdStatusDoBy(int associateId, AppointmentStatus status, DateTime doBy)
Parameters
Returns
IdxAssociateIdType(int, AppointmentType)
Shortcut method for looking up using the database index AssociateIdType, which spans the following fields:
| Field | Description |
|---|
| AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
| Type | where=no start time,note,docin, docout |
Declaration
public Restriction IdxAssociateIdType(int associateId, AppointmentType type)
Parameters
Returns
IdxAssociateIdTypeEndDate(int, AppointmentType, DateTime)
Shortcut method for looking up using the database index AssociateIdTypeEndDate, which spans the following fields:
| Field | Description |
|---|
| AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
| Type | where=no start time,note,docin, docout |
| EndDate | Date + end time planned |
Declaration
public Restriction IdxAssociateIdTypeEndDate(int associateId, AppointmentType type, DateTime endDate)
Parameters
Returns
IdxAssociateIdTypeStatus(int, AppointmentType, AppointmentStatus)
Shortcut method for looking up using the database index AssociateIdTypeStatus, which spans the following fields:
| Field | Description |
|---|
| AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
| Type | where=no start time,note,docin, docout |
| Status | status=done,started, not started, hidden |
Declaration
public Restriction IdxAssociateIdTypeStatus(int associateId, AppointmentType type, AppointmentStatus status)
Parameters
Returns
Shortcut method for looking up using the database index ContactId, which spans the following fields:
| Field | Description |
|---|
| ContactId | Contact ID of owning contact, may be 0 |
Declaration
public Restriction IdxContactId(int contactId)
Parameters
| Type |
Name |
Description |
| int |
contactId |
|
Returns
IdxMotherId(int)
Shortcut method for looking up using the database index MotherId, which spans the following fields:
| Field | Description |
|---|
| MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
Declaration
public Restriction IdxMotherId(int motherId)
Parameters
| Type |
Name |
Description |
| int |
motherId |
|
Returns
IdxMotherIdStatus(int, AppointmentStatus)
Shortcut method for looking up using the database index MotherIdStatus, which spans the following fields:
| Field | Description |
|---|
| MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
| Status | status=done,started, not started, hidden |
Declaration
public Restriction IdxMotherIdStatus(int motherId, AppointmentStatus status)
Parameters
Returns
IdxMotherIdStatusActiveDate(int, AppointmentStatus, DateTime)
Shortcut method for looking up using the database index MotherIdStatusActiveDate, which spans the following fields:
| Field | Description |
|---|
| MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
| Status | status=done,started, not started, hidden |
| ActiveDate | The date to be used for searching & showing |
Declaration
public Restriction IdxMotherIdStatusActiveDate(int motherId, AppointmentStatus status, DateTime activeDate)
Parameters
Returns
IdxMotherIdStatusActiveDateRegisteredAssociateId(int, AppointmentStatus, DateTime, int)
Shortcut method for looking up using the database index MotherIdStatusActiveDateRegisteredAssociateId, which spans the following fields:
| Field | Description |
|---|
| MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
| Status | status=done,started, not started, hidden |
| ActiveDate | The date to be used for searching & showing |
| RegisteredAssociateId | Registered by whom |
Declaration
public Restriction IdxMotherIdStatusActiveDateRegisteredAssociateId(int motherId, AppointmentStatus status, DateTime activeDate, int registeredAssociateId)
Parameters
Returns
IdxMotherIdStatusActiveDateRegisteredAssociateIdRegistered(int, AppointmentStatus, DateTime, int, DateTime)
Shortcut method for looking up using the database index MotherIdStatusActiveDateRegisteredAssociateIdRegistered, which spans the following fields:
| Field | Description |
|---|
| MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
| Status | status=done,started, not started, hidden |
| ActiveDate | The date to be used for searching & showing |
| RegisteredAssociateId | Registered by whom |
| Registered | Registered date |
Declaration
public Restriction IdxMotherIdStatusActiveDateRegisteredAssociateIdRegistered(int motherId, AppointmentStatus status, DateTime activeDate, int registeredAssociateId, DateTime registered)
Parameters
Returns
IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedBy(int, AppointmentStatus, DateTime, int, DateTime, int)
Shortcut method for looking up using the database index MotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedBy, which spans the following fields:
| Field | Description |
|---|
| MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
| Status | status=done,started, not started, hidden |
| ActiveDate | The date to be used for searching & showing |
| RegisteredAssociateId | Registered by whom |
| Registered | Registered date |
| AssignedBy | Who (last) assigned this appointment to associate_id? |
Declaration
public Restriction IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedBy(int motherId, AppointmentStatus status, DateTime activeDate, int registeredAssociateId, DateTime registered, int assignedBy)
Parameters
Returns
IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdx(int, AppointmentStatus, DateTime, int, DateTime, int, int)
Shortcut method for looking up using the database index MotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdx, which spans the following fields:
| Field | Description |
|---|
| MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
| Status | status=done,started, not started, hidden |
| ActiveDate | The date to be used for searching & showing |
| RegisteredAssociateId | Registered by whom |
| Registered | Registered date |
| AssignedBy | Who (last) assigned this appointment to associate_id? |
| GroupIdx | Group of owning associate at the time tha ppnt was created |
Declaration
public Restriction IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdx(int motherId, AppointmentStatus status, DateTime activeDate, int registeredAssociateId, DateTime registered, int assignedBy, int groupIdx)
Parameters
Returns
IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxType(int, AppointmentStatus, DateTime, int, DateTime, int, int, AppointmentType)
Shortcut method for looking up using the database index MotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxType, which spans the following fields:
| Field | Description |
|---|
| MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
| Status | status=done,started, not started, hidden |
| ActiveDate | The date to be used for searching & showing |
| RegisteredAssociateId | Registered by whom |
| Registered | Registered date |
| AssignedBy | Who (last) assigned this appointment to associate_id? |
| GroupIdx | Group of owning associate at the time tha ppnt was created |
| Type | where=no start time,note,docin, docout |
Declaration
public Restriction IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxType(int motherId, AppointmentStatus status, DateTime activeDate, int registeredAssociateId, DateTime registered, int assignedBy, int groupIdx, AppointmentType type)
Parameters
Returns
IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxTypeAssociateId(int, AppointmentStatus, DateTime, int, DateTime, int, int, AppointmentType, int)
Shortcut method for looking up using the database index MotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxTypeAssociateId, which spans the following fields:
| Field | Description |
|---|
| MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
| Status | status=done,started, not started, hidden |
| ActiveDate | The date to be used for searching & showing |
| RegisteredAssociateId | Registered by whom |
| Registered | Registered date |
| AssignedBy | Who (last) assigned this appointment to associate_id? |
| GroupIdx | Group of owning associate at the time tha ppnt was created |
| Type | where=no start time,note,docin, docout |
| AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
Declaration
public Restriction IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxTypeAssociateId(int motherId, AppointmentStatus status, DateTime activeDate, int registeredAssociateId, DateTime registered, int assignedBy, int groupIdx, AppointmentType type, int associateId)
Parameters
Returns
IdxProjectId(int)
Shortcut method for looking up using the database index ProjectId, which spans the following fields:
| Field | Description |
|---|
| ProjectId | ID of project referred to, may be 0 |
Declaration
public Restriction IdxProjectId(int projectId)
Parameters
| Type |
Name |
Description |
| int |
projectId |
|
Returns
IdxProjectIdType(int, AppointmentType)
Shortcut method for looking up using the database index ProjectIdType, which spans the following fields:
| Field | Description |
|---|
| ProjectId | ID of project referred to, may be 0 |
| Type | where=no start time,note,docin, docout |
Declaration
public Restriction IdxProjectIdType(int projectId, AppointmentType type)
Parameters
Returns
IdxProjectIdTypeActiveDate(int, AppointmentType, DateTime)
Shortcut method for looking up using the database index ProjectIdTypeActiveDate, which spans the following fields:
| Field | Description |
|---|
| ProjectId | ID of project referred to, may be 0 |
| Type | where=no start time,note,docin, docout |
| ActiveDate | The date to be used for searching & showing |
Declaration
public Restriction IdxProjectIdTypeActiveDate(int projectId, AppointmentType type, DateTime activeDate)
Parameters
Returns
IdxProjectIdTypeActiveDateDocumentId(int, AppointmentType, DateTime, int)
Shortcut method for looking up using the database index ProjectIdTypeActiveDateDocumentId, which spans the following fields:
| Field | Description |
|---|
| ProjectId | ID of project referred to, may be 0 |
| Type | where=no start time,note,docin, docout |
| ActiveDate | The date to be used for searching & showing |
| DocumentId | Points to document record; 0 for non-document appointments! |
Declaration
public Restriction IdxProjectIdTypeActiveDateDocumentId(int projectId, AppointmentType type, DateTime activeDate, int documentId)
Parameters
Returns
IdxProjectIdTypeActiveDateDocumentIdAssociateId(int, AppointmentType, DateTime, int, int)
Shortcut method for looking up using the database index ProjectIdTypeActiveDateDocumentIdAssociateId, which spans the following fields:
| Field | Description |
|---|
| ProjectId | ID of project referred to, may be 0 |
| Type | where=no start time,note,docin, docout |
| ActiveDate | The date to be used for searching & showing |
| DocumentId | Points to document record; 0 for non-document appointments! |
| AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
Declaration
public Restriction IdxProjectIdTypeActiveDateDocumentIdAssociateId(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId)
Parameters
Returns
IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdx(int, AppointmentType, DateTime, int, int, int)
Shortcut method for looking up using the database index ProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdx, which spans the following fields:
| Field | Description |
|---|
| ProjectId | ID of project referred to, may be 0 |
| Type | where=no start time,note,docin, docout |
| ActiveDate | The date to be used for searching & showing |
| DocumentId | Points to document record; 0 for non-document appointments! |
| AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
| GroupIdx | Group of owning associate at the time tha ppnt was created |
Declaration
public Restriction IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdx(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId, int groupIdx)
Parameters
Returns
IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherId(int, AppointmentType, DateTime, int, int, int, int)
Shortcut method for looking up using the database index ProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherId, which spans the following fields:
| Field | Description |
|---|
| ProjectId | ID of project referred to, may be 0 |
| Type | where=no start time,note,docin, docout |
| ActiveDate | The date to be used for searching & showing |
| DocumentId | Points to document record; 0 for non-document appointments! |
| AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
| GroupIdx | Group of owning associate at the time tha ppnt was created |
| MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
Declaration
public Restriction IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherId(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId, int groupIdx, int motherId)
Parameters
Returns
IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedBy(int, AppointmentType, DateTime, int, int, int, int, int)
Shortcut method for looking up using the database index ProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedBy, which spans the following fields:
| Field | Description |
|---|
| ProjectId | ID of project referred to, may be 0 |
| Type | where=no start time,note,docin, docout |
| ActiveDate | The date to be used for searching & showing |
| DocumentId | Points to document record; 0 for non-document appointments! |
| AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
| GroupIdx | Group of owning associate at the time tha ppnt was created |
| MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
| AssignedBy | Who (last) assigned this appointment to associate_id? |
Declaration
public Restriction IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedBy(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId, int groupIdx, int motherId, int assignedBy)
Parameters
Returns
IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedByAppointmentId(int, AppointmentType, DateTime, int, int, int, int, int, int)
Shortcut method for looking up using the database index ProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedByAppointmentId, which spans the following fields:
| Field | Description |
|---|
| ProjectId | ID of project referred to, may be 0 |
| Type | where=no start time,note,docin, docout |
| ActiveDate | The date to be used for searching & showing |
| DocumentId | Points to document record; 0 for non-document appointments! |
| AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
| GroupIdx | Group of owning associate at the time tha ppnt was created |
| MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
| AssignedBy | Who (last) assigned this appointment to associate_id? |
| AppointmentId | Primary key |
Declaration
public Restriction IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedByAppointmentId(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId, int groupIdx, int motherId, int assignedBy, int appointmentId)
Parameters
Returns
IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedByAppointmentIdRegistered(int, AppointmentType, DateTime, int, int, int, int, int, int, DateTime)
Shortcut method for looking up using the database index ProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedByAppointmentIdRegistered, which spans the following fields:
| Field | Description |
|---|
| ProjectId | ID of project referred to, may be 0 |
| Type | where=no start time,note,docin, docout |
| ActiveDate | The date to be used for searching & showing |
| DocumentId | Points to document record; 0 for non-document appointments! |
| AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
| GroupIdx | Group of owning associate at the time tha ppnt was created |
| MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
| AssignedBy | Who (last) assigned this appointment to associate_id? |
| AppointmentId | Primary key |
| Registered | Registered date |
Declaration
public Restriction IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedByAppointmentIdRegistered(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId, int groupIdx, int motherId, int assignedBy, int appointmentId, DateTime registered)
Parameters
Returns
IdxRecurrenceRuleId(int)
Shortcut method for looking up using the database index RecurrenceRuleId, which spans the following fields:
| Field | Description |
|---|
| RecurrenceRuleId | Pointer to recurrence rule, for recurring appointments, otherwise 0 |
Declaration
public Restriction IdxRecurrenceRuleId(int recurrenceRuleId)
Parameters
| Type |
Name |
Description |
| int |
recurrenceRuleId |
|
Returns
IdxRecurrenceRuleIdActiveDate(int, DateTime)
Shortcut method for looking up using the database index RecurrenceRuleIdActiveDate, which spans the following fields:
| Field | Description |
|---|
| RecurrenceRuleId | Pointer to recurrence rule, for recurring appointments, otherwise 0 |
| ActiveDate | The date to be used for searching & showing |
Declaration
public Restriction IdxRecurrenceRuleIdActiveDate(int recurrenceRuleId, DateTime activeDate)
Parameters
| Type |
Name |
Description |
| int |
recurrenceRuleId |
|
| DateTime |
activeDate |
|
Returns
IdxType(AppointmentType)
Shortcut method for looking up using the database index Type, which spans the following fields:
| Field | Description |
|---|
| Type | where=no start time,note,docin, docout |
Declaration
public Restriction IdxType(AppointmentType type)
Parameters
Returns
Implements
Extension Methods