Emails
Query Emails that are visible to the authenticated user and related to a specific Person, Company, Case, or Deal.
テーブル固有の情報
Select
Email の取得には、People、Company、Case、もしくはDeal などのEmail が所属するSebjectType およびSubject Id を入力します。
SELECT * FROM Emails WHERE SubjectType = 'People' AND SubjectId = '1234567' SELECT * FROM Emails WHERE SubjectType = 'Company' AND SubjectId = '1234567'
特定のEmail に関連する情報の取得には Email のId を指定します。
SELECT * FROM Emails WHERE Id = '1234567'
すべての会社からすべてのE メールを取得するには、IN 演算子でサブクエリを使用できます。
SELECT * FROM Emails WHERE SubjectType = 'Company' AND SubjectId IN (SELECT Id FROM Companies)
Datetime カラムでは、'>'、および'>=' の演算子だけがサポートされています。
SELECT * FROM Emails WHERE SubjectType = 'People' AND SubjectId = '1234567' AND UpdatedAt > "2016-01-01"
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | The unique identifier of the email. | |
| Title | String | The title of the email. | |
| Body | String | The body of the email. | |
| AuthorId | Integer | The Id of the author of the email. | |
| SubjectId | Integer | The Id of the subject of the email. | |
| SubjectType | String | The subject type of the email. The allowed values are People, Company, Case, Deal. | |
| SubjectName | String | The subject name of the email. | |
| CollectionId | Integer | The Id of the collection. | |
| CollectionType | String | The type of the collection. | |
| VisibleTo | String | Who the email is visible to: Everyone, Owner, or NamedGroup. | |
| OwnerId | Integer | The Id of the owner associated with the email. | |
| GroupId | Integer | The Id of the group associated with the email. | |
| CreatedAt | Datetime | The date and time when the email was created. | |
| UpdatedAt | Datetime | The date and time when the email was last updated. |