EmailAddress
Create, update, delete, and query email addresses saved in SuiteCRM
テーブル固有の情報
Select
WHERE 句で任意の条件を使用して、Email Address テーブルをクエリできます。本製品 はSuiteCRM API を使用して結果をフィルタリングします。
SELECT * FROM [Email Address] WHERE [Invalid Email] = True
Insert
書き込み可能なカラムを指定して、Email Address を作成します。
INSERT INTO [Email Address] ([Email address]) VALUES ('[email protected]')
Update
Id を指定して、書き込み可能なEmail Address カラムを更新できます。
UPDATE [Email Address] SET [Opted out] = True WHERE Id = 'Test123'
Delete
Id を指定して、Email Address を削除します。
DELETE FROM [Email Address] WHERE Id = '10003'
Columns
Name | Type | ReadOnly | Description |
ID [KEY] | String | False |
The unique identifier of the email address. |
DateCreate | Datetime | True |
The date the email address was created. |
DateModified | Datetime | True |
The date the email address was last modified. |
Delete | Bool | False |
Whether the email address is deleted. |
EmailAddress | String | False |
The email address. |
EmailAddresscaps | String | False |
The email address in uppercase. |
InvalidEmail | Bool | False |
Whether the email address is marked as invalid. |
OptedOut | Bool | False |
Whether the email address is marked as opt out. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
Rows@Next | String |
Identifier for the next page of results. Do not set this value manually. |