EmailTemplates

Create, update, delete, and query email templates to be used for emails

テーブル固有の情報

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

SELECT * FROM [Email Templates] WHERE Published = True

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

INSERT INTO [Email Templates] (Name, Description) VALUES ('Example', 'Creating an example email')

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

UPDATE [Email Templates] SET [Text Only] = True WHERE Id = 'Test123'

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

DELETE FROM Emails WHERE Id = '10003'


Name	Type	ReadOnly	Description
ID [KEY]	String	False	The unique identifier of the email template.
AssignedUserId	String	False	The Id of the user assigned to the record.
AssignedUserName	String	False	The user name of the user assigned to the record.
Body	String	False	Plaintext body of the resulting email.
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.
Deleted	Bool	False	The record deletion indicator.
Description	String	False	The description for the email template.
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 email template.
PlainText	String	False	The HTML-formatted body of the resulting email.
Published	Bool	False	The published status of the record.
Subject	String	False	The subject of the resulting email.
TextOnly	Bool	False	Whether the email template is to be sent in text only.
Type	String	False	The type of the email template.

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


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