JDBC Driver for Salesforce

Build 26.0.9770

EmailMessageRelation

Associates an email message with a related record, such as a contact or lead.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier for the record.

EmailMessageId String False

EmailMessage.Id

ID of the EmailMessage associated with this record.

RelationId String False

ID of the Relation associated with this record.

RelationType String False

Type classification for Relation.

RelationAddress String False

Field containing RelationAddress information.

RelationObjectType String True

Type classification for RelationObject.

CreatedDate Datetime True

Date and time when the record was created.

CreatedById String True

User.Id

ID of the user who created the record.

IsDeleted Bool True

Indicates whether the record has been moved to the Recycle Bin.

SystemModstamp Datetime True

Date and time when the record was last modified by a user or by an automated process.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name Type Description
RelationIdType String

Specifies the type of the 'RelationId' polymorphic field to use in the statement.

RelationIdExternalFieldName String

Specifies the external field name of the 'RelationId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement

SOQL String

Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query.

ExternalIdColumn String

Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called.

FilterScope String

Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770