MailMessages

Returns data about a specific mail message.

Columns


Name	Type	Description
Id [KEY]	Integer	ID of the Mail Threads.
PartiesTo	String	To.
PartiesFrom	String	From.
DraftParties	String	Draft Parties.
Folders	String	Folders.
AccountId	String	Account Id.
UserId	Integer	User Id.
Version	Integer	Version.
Subject	String	Subject.
Snippet	String	Snippet.
SnippetDraft	String	SnippetDraft.
SnippetSent	String	SnippetSent.
HasAttachmentsFlag	Integer	HasAttachmentsFlag.
HasInlineAttachmentsFlag	Integer	HasInlineAttachmentsFlag.
HasRealAttachmentsFlag	Integer	HasRealAttachmentsFlag.
HasDraftFlag	Integer	HasDraftFlag.
HasSentFlag	Integer	HasSentFlag.
ArchivedFlag	Integer	ArchivedFlag.
DeletedFlag	Integer	DeletedFlag.
SyncedFlag	Integer	SyncedFlag.
ExternalDeletedFlag	Integer	ExternalDeletedFlag.
SmartBccFlag	Integer	SmartBccFlag.
FirstMessageToMeFlag	Integer	FirstMessageToMeFlag.
MailLinkTrackingEnabledFlag	Integer	MailLinkTrackingEnabledFlag.
LastMessageTimestamp	String	LastMessageTimestamp.
FirstMessageTimestamp	String	FirstMessageTimestamp.
LastMessageSentTimestamp	String	LastMessageSentTimestamp.
LastMessageReceivedTimestamp	String	LastMessageReceivedTimestamp.
AddTime	String	AddTime.
UpdateTime	String	UpdateTime.
DealId	Integer	DealId.
DealStatus	Integer	DealStatus.
AllMessagesSentFlag	Integer	AllMessagesSentFlag.

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