Campaigns

Create, update, delete, and query the SuiteCRM project's campaigns

テーブル固有の情報

Select

WHERE 句で任意の条件を使用して、Campaigns テーブルをクエリできます。本製品はSuiteCRM API を使用して結果をフィルタリングします。

SELECT * FROM Campaigns WHERE Budget < 10000

Insert

書き込み可能なカラムを指定して、Campaign を作成します。

INSERT INTO Campaigns (Name, [Expected Cost], [Actual Cost]) VALUES ('Suite Campaign', 30000, 29400)

Update

Id を指定して、書き込み可能なCampaign カラムを更新できます。

UPDATE Campaigns SET Budget = 30000 WHERE Id = 'Test123'

Delete

Id を指定して、Campaign を削除します。

DELETE FROM Campaigns WHERE Id = '10003'

Columns


Name	Type	ReadOnly	Description
ID [KEY]	String	False	The unique identifier of the campaign.
ActualCost	Double	False	Actual cost of the campaign.
AssignedUserId	String	False	The Id of the user assigned to the record.
AssignedUserName	String	True	The user name of the user assigned to the record.
Budget	Double	False	Budgeted amount for the campaign.
Content	String	False	The campaign description.
CreatedById	String	True	The Id of the user who created the record.
CreatedByName	String	True	The name of the user who created the record.
Currency	String	False	Currency in use for the campaign.
DateCreated	Datetime	True	The date the record was created.
DateModified	Datetime	True	The date the record was last modified.
Deleted	Bool	False	The record deletion indicator.
Description	String	True	The description for the campaign.
EndDate	Date	False	Ending date of the campaign.
ExpectedCost	Double	False	Expected cost of the campaign.
ExpectedRevenue	Double	False	Expected revenue stemming from the campaign.
Frequency	String	False	Frequency of the campaign.
Impressions	Int	False	Expected click throughs manually entered by the campaign manager.
ModifiedById	String	True	The Id of the user who last modified the record.
ModifiedByName	String	True	The name of the user who last modified the record.
Name	String	False	The name of the campaign.
Objective	String	False	The objective of the campaign.
StartDate	Date	False	Starting date of the campaign.
Status	String	False	Status of the campaign.
Tracker	Int	False	The internal Id of the tracker used in a campaign. 2. (See CampaignTrackers.)
TrackerCount	Int	False	The number of accesses made to the tracker URL; no longer used as of 4.2. (See CampaignTrackers.)
TrackerLinkText	String	False	The text that appears in the tracker URL. No longer used as of 4.2. (See CampaignTrackers.)
TrackerRedirectURL	String	False	The URL referenced in the tracker URL. No longer used as of 4.2. (See CampaignTrackers.)
Type	String	False	The type of the campaign.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
Rows@Next	String	Identifier for the next page of results. Do not set this value manually.

JDBC Driver for SuiteCRM