Projects
Create, update, delete, and query projects registered in SuiteCRM
テーブル固有の情報
Select
WHERE 句で任意の条件を使用して、Projects テーブルをクエリできます。本製品 はSuiteCRM API を使用して結果をフィルタリングします。
SELECT * FROM Projects WHERE Name = 'test'
Insert
書き込み可能なカラムを指定して、Project を作成します。
INSERT INTO Projects (Id, Name) VALUES ('id', 'Energy')
Update
Id を指定して、書き込み可能なProject カラムを更新できます。
UPDATE Projects SET Name = 'new name', Description = 'Desc' WHERE Id = 'Test123'
Delete
Id を指定して、Project を削除します。
DELETE FROM Projects WHERE Id = 10003
Columns
Name | Type | ReadOnly | Description |
SecurityGroups | String | True |
The security group associated with the record. |
Id [KEY] | String | False |
The unique identifier of the project. |
DateEntered | Datetime | False |
The date the record was created. |
DateModified | Datetime | False |
The date the record was last modified. |
AssignedUserId | String | False |
|
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. |
Name | String | False |
Project name. |
Description | String | False |
Project description. |
Deleted | Bool | False |
The record deletion indicator. |
EstimatedStartDate | String | False |
|
EstimatedEndDate | String | False |
|
Status | String | False |
The status of the record. |
Priority | String | False |
The priority of the record. |
TotalEstimatedEffort | String | False |
|
TotalActualEffort | String | False |
|
Accounts | String | True |
The accounts associated with the record |
Quotes | String | True |
|
Contacts | String | True |
The contacts associated with the record |
Opportunities | String | True |
The opportunities associated with the record. |
Notes | String | True |
The notes associated with the record. |
Tasks | String | True |
The tasks associated with the record. |
Meetings | String | True |
The meetings associated with the record. |
Calls | String | True |
The calls associated with the record |
Emails | String | True |
The emails associated with the record |
Projecttask | String | True |
|
CreatedByLink | String | True |
Link to the record who created it |
ModifiedUserLink | String | True |
Link to the record who modified it. |
AssignedUserLink | String | True |
Link to the user which the record has been assigned to |
AssignedUserName | String | False |
|
Cases | String | True |
The cases associated with the record. |
Bugs | String | True |
The bugs associated with the record. |
Products | String | True |
|
ProjectUsers1 | String | True |
|
AmProjecttemplatesProject1 | String | True |
|
AmProjecttemplatesProject1Name | String | True |
|
AmProjecttemplatesProject1amProjecttemplatesIda | String | True |
|
ProjectContacts1 | String | True |
|
AosQuotesProject | String | True |
|
OverrideBusinessHours | Bool | False |
|
JjwgMapsLatC | Double | False |
|
JjwgMapsLngC | Double | False |
|
JjwgMapsGeocodeStatusC | String | False |
|
JjwgMapsAddressC | String | False |
|