Meetings
Create, update, delete, and query Meetings created in SuiteCRM
テーブル固有の情報
Select
WHERE 句で任意の条件を使用して、Meetings テーブルをクエリできます。本製品 はSuiteCRM API を使用して結果をフィルタリングします。
SELECT * FROM Meetings WHERE Name = 'test'
Insert
書き込み可能なカラムを指定して、Meeting を作成します。
INSERT INTO Meetings (Id, Name) VALUES ('id', 'Energy')
Update
Id を指定して、書き込み可能なMeeting カラムを更新できます。
UPDATE Meetings SET Name = 'new name', Description = 'Desc' WHERE Id = 'Test123'
Delete
Id を指定して、Meeting を削除します。
DELETE FROM Meetings WHERE Id = 10003
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | False |
The unique identifier for the meeting. |
Name | String | False |
|
DateEntered | Datetime | False |
The date the record was created. |
DateModified | Datetime | False |
The date the record was last modified. |
ModifiedUserId | String | False |
The Id of the user who last modified the record. |
ModifiedByName | String | True |
The name of the user who last modified the record. |
CreatedBy | String | False |
The Id of the user who created the record. |
CreatedByName | String | True |
The name of the user who created the record. |
Description | String | False |
Full text of the note. |
Deleted | Bool | False |
The record deletion indicator. |
CreatedByLink | String | True |
Link to the record who created it |
ModifiedUserLink | String | True |
Link to the record who modified it. |
AssignedUserId | String | False |
The Id of the user assigned to the record. |
AssignedUserName | String | True |
|
AssignedUserLink | String | True |
Link to the user which the record has been assigned to |
SecurityGroups | String | True |
The security group associated with the record. |
AcceptStatus | String | False |
|
SetAcceptLinks | String | False |
|
Location | String | False |
The location of the meeting. |
Password | String | False |
|
JoinUrl | String | False |
|
HostUrl | String | False |
The host URL. |
DisplayedUrl | String | False |
|
Creator | String | False |
|
ExternalId | String | False |
|
DurationHours | String | False |
The duration (hours). |
DurationMinutes | String | False |
The duration (minutes). |
DateStart | Datetime | False |
|
DateEnd | Datetime | False |
|
ParentType | String | False |
Module the meeting is associated with. |
Status | String | False |
The status of the record. |
Type | String | False |
Meeting type (e.g., WebEx, or Other). |
Direction | String | False |
Whether the meeting is inbound or outbound. |
ParentId | String | False |
The Id of the parent of this account. |
ReminderChecked | Bool | False |
Whether or not the reminder value is set. |
ReminderTime | String | False |
Specifies when a reminder alert should be issued: -1 means no alert; otherwise the number of seconds prior to the start. |
EmailReminderChecked | Bool | False |
|
EmailReminderTime | String | False |
Specifies when a email reminder alert should be issued: -1 means no alert; otherwise the number of seconds prior to the start. |
EmailReminderSent | Bool | False |
Whether the email reminder is already sent. |
Reminders | String | False |
List of reminders set for the meetings |
OutlookId | String | False |
When the Sugar Plug-in for Microsoft Outlook syncs an Outlook appointment, this is the Outlook appointment item Id. |
Sequence | String | False |
|
ContactName | String | False |
|
Contacts | String | True |
The contacts associated with the record |
ParentName | String | True |
The name of the parent of this account. |
Users | String | True |
|
Accounts | String | True |
The accounts associated with the record |
Leads | String | True |
The leads associated with the record. |
Opportunity | String | True |
|
Case | String | True |
|
AosContracts | String | True |
|
Notes | String | True |
The notes associated with the record. |
ContactId | String | False |
The Id of the associated contact. |
RepeatType | String | False |
Type of a recurring meeting. |
RepeatInterval | String | False |
The interval of a recurring meeting. |
RepeatDow | String | False |
The day of week of a meeting. |
RepeatUntil | String | False |
Repeat until the specified date. |
RepeatCount | String | False |
Number of recurrences. |
RepeatParentId | String | False |
Id of the first element of recurring records. |
RecurringSource | String | False |
Source of recurring meeting. |
Duration | String | False |
Duration handler dropdown. |
GsyncId | String | False |
|
GsyncLastsync | String | False |
|
JjwgMapsLatC | Double | False |
|
JjwgMapsLngC | Double | False |
|
JjwgMapsGeocodeStatusC | String | False |
|
JjwgMapsAddressC | String | False |
|