Calls
Create, update, delete, and query the SuiteCRM project's Calls
テーブル固有の情報
Select
WHERE 句で任意の条件を使用して、Calls テーブルをクエリできます。本製品 はSuiteCRM API を使用して結果をフィルタリングします。
SELECT * FROM Calls WHERE Name = 'test'
Insert
書き込み可能なカラムを指定して、Call を作成します。
INSERT INTO Calls (Id, Name) VALUES ('id', 'Energy')
Update
Id を指定して、書き込み可能なCall カラムを更新できます。
UPDATE Calls SET Name = 'new name', Description = 'Desc' WHERE Id = 'Test123'
Delete
Id を指定して、Call を削除します。
DELETE FROM Calls WHERE Id = '10003'
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | False |
The unique identifier of the call. |
Name | String | False |
A brief description of the call. |
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 |
The full text of the note. |
Deleted | Bool | False |
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 |
|
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. |
DurationHours | String | False |
The hours portion of the call duration. |
DurationMinutes | String | False |
The minutes portion of the call duration. |
DateStart | Datetime | False |
|
DateEnd | Datetime | False |
|
ParentType | String | False |
The type of the parent Sugar object related to the call. |
ParentName | String | True |
The name of the parent of this account. |
Status | String | False |
The status of the record. |
Direction | String | False |
Indicates whether call is inbound or outbound. |
ParentId | String | False |
The Id of the parent of this account. |
ReminderChecked | Bool | False |
The checkbox indicating whether or not the reminder value is set. |
ReminderTime | String | False |
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 |
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 for the call |
OutlookId | String | False |
When the Suite Plug-in for Microsoft Outlook syncs an Outlook appointment, this is the Outlook appointment item Id. |
AcceptStatus | String | False |
|
SetAcceptLinks | String | False |
|
ContactName | String | False |
|
Opportunities | String | True |
The opportunities associated with the record. |
Leads | String | True |
The leads associated with the record. |
Project | String | True |
The project associated with the record. |
Case | String | True |
|
Accounts | String | True |
The accounts associated with the record |
Contacts | String | True |
The contacts associated with the record |
AosContracts | String | True |
|
Users | String | True |
|
Notes | String | True |
The notes associated with the record. |
ContactId | String | False |
The Id of the contact for the call. |
RepeatType | String | False |
The type of recurrence. |
RepeatInterval | String | False |
The interval of recurrence. |
RepeatDow | String | False |
The days of week in recurrence. |
RepeatUntil | String | False |
Repeat until the specified date. |
RepeatCount | String | False |
Number of recurrences. |
RepeatParentId | String | False |
The Id of the first element of recurring records. |
RecurringSource | String | False |
The recurring source requesting the call |
RescheduleHistory | String | False |
|
RescheduleCount | String | False |
|
CallsReschedule | String | True |
|