ODBC Driver for Oracle Eloqua

Build 24.0.9060

EmailHeader

Create, update, delete, and query Email Headers.

Table Specific Information

Select

The following limitation exists for filtering on datetime columns: The "=" operator cannot be used with datetime columns in the WHERE clause. However, the "<", ">", ">=", and "<=" operators can be used to filter on datetime columns.

Additionally, the UpdatedAt column only supports filtering with the '>' operator.

Oracle Eloqua also has limited support on multiple conditions. In many tables the AND condition between filters is not supported. If AND is included the server might not return any results, nor will it return an error.

Columns

Name Type ReadOnly Description
ID [KEY] Long True

The unique identifier for the email header.

Name String False

The name of the email header.

Body String False

The body of the email header.

Hyperlinks String True

A list of hyperlinks.

FieldMerges String True

A list of field merges.

Text String False

The text of the email header.

Permissions String False

The permissions of the email header.

Description String False

The description of the email header.

FolderId Long False

The Id of the folder for the email header.

CreatedAt Datetime True

Date the email header was created.

CreatedBy String True

The Id of the user who created the email header.

AccessedAt Datetime False

Date the email header was accessed.

CurrentStatus String False

The current status of the email header.

Depth String False

The depth of the email header.

UpdatedAt Datetime True

Date the email header was updated.

UpdatedBy String True

The Id of the user who last updated the email header.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060