TargetLists

Create, update, delete, and query the saved target lists.

テーブル固有の情報

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

SELECT * FROM [Target Lists] WHERE [Targets in List] > 2

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

INSERT INTO [Target Lists] (Name, Type, [Assigned User Id]) VALUES ('Test Account', 'Default', 'UserId42')

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

UPDATE [Target Lists] SET [Domain Name] = 'New Domain', Type = 'seed' WHERE Id = 'Test123'

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

DELETE FROM [Target Lists] WHERE Id = 10003


Name	Type	ReadOnly	Description
ID [KEY]	String	False	The Id of the target list.
Assignedto	String	True	The user name of the user assigned to the record.
AssignedUserId	String	False	The Id of the user assigned to the record.
CreatedBy	Bool	False	The record deletion indicator.
CreatedById	String	True	The Id of the user who created the record.
CreatedByName	String	True	The name of the user who created the record.
DateCreated	Datetime	True	The date the record was created.
DateModified	Datetime	True	The date the record was last modified.
Description	String	False	The description of the target list.
DomainName	String	False	The domain name of the target list.
MarketingId	String	True	The marketing Id of the target list.
MarketingName	String	True	The marketing name of the target list.
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 target list.
TargetsinList	Int	True	The entry count of the prospect list.
Type	String	False	The type of the target list.

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


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