CampaignLog
Create, update, delete, and query logs related to SuiteCRM campaigns
テーブル固有の情報
Select
WHERE 句で任意の条件を使用して、Campaign Log テーブルをクエリできます。本製品 はSuiteCRM API を使用して結果をフィルタリングします。
SELECT * FROM [Campaign Log] WHERE Campaign_Id = 'campaign1'
Insert
書き込み可能なカラムを指定して、Campaign Log を作成します。
INSERT INTO [Campaign Log] (Name, Campaign_Id) VALUES ('Test Log', 'Campaign2')
Update
Id を指定して、書き込み可能なCampaign Log カラムを更新できます。
UPDATE [Campaign Log] SET Archived = true WHERE Id = 'Test123'
Delete
Id を指定して、Campaign Log を削除します。
DELETE FROM [Campaign Log] WHERE Id = '10003'
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | False |
The unique identifier of the record. |
| ActivityDate | Datetime | False |
The date the activity occurred. |
| ActivityType | String | False |
The activity that occurred (e.g., Viewed Message, Bounced, or Opted out). |
| Archived | Bool | False |
Indicates if the item has been archived. |
| campaign_content | String | True |
The campaign content. |
| campaign_id | String | False |
The identifier of the campaign associated with the campaign log. |
| campaign_name | String | True |
The name of the campaign associated with the campaign log. |
| campaign_objective | String | True |
The campaign objective. |
| DateModified | Datetime | False |
The date the campaign log was last modified. |
| Deleted | Bool | False |
Record deletion indicator. |
| Hits | Int | False |
Number of times the item has been invoked (e.g., multiple click throughs). |
| LBL_MARKETING_ID | String | False |
The Id of the marketing email this entry is associated with. |
| marketing_name | String | False |
The marketing name. |
| MoreInformation | String | False |
More information about the campaign log. |
| Name | String | True |
The name of the campaign associated with the campaign log. |
| ProspectListID | String | False |
The prospect list from which the item originated. |
| recipient_email | String | True |
The email of the recipient. |
| recipient_name | String | True |
The name of the recipient. |
| RelatedId | String | False |
The Id of the related record. |
| RelatedType | String | False |
The type of the related record. |
| TargetID | String | False |
The identifier of the target record. |
| TargetTrackerKey | String | False |
The identifier of the tracker URL. |
| TargetType | String | False |
The target record type (e.g., Contact or Lead). |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Rows@Next | String |
Identifier for the next page of results. Do not set this value manually. |