EmailGroup
Create, update, delete, and query Email Groups.
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 of the email group. |
| Name | String | False |
The name of the email. |
| DisplayName | String | False |
The display name of the email group. |
| EmailFooterId | Long | False |
The Id of the email footer of the email group. |
| EmailIds | String | False |
The Ids of the emails in the email group. |
| IsVisibleInOutlookPlugin | Boolean | False |
Identifies whether the email group is visible in the Outlook plugin. |
| IsVisibleInPublicSubscriptionList | Boolean | False |
Identifies whether the email group is visible in public subscription list. |
| SubscriptionLandingPageId | Long | False |
The Id of the landing page used to subscribe to the email group. |
| SubscriptionListId | Long | False |
The Id of the subscription list for the email group. |
| UnsubscriptionLandingPageId | Long | False |
The Id of the landing page used to unsubscribe for the email group. |
| UnsubscriptionListId | Long | False |
The Id of the unsubscription list for the email group. |
| UnsubscriptionListDataLookupId | String | False |
The Id of the data lookup for the unsubscription list for the email group. |
| Description | String | False |
The description of the email group. |
| FolderId | Long | False |
The folder Id for the email group. |
| Permissions | String | False |
The permissions list of the email group. |
| CreatedAt | Datetime | True |
Date the email group was created. |
| CreatedBy | String | True |
The Id of the user who created the email group. |
| AccessedAt | Datetime | False |
Date the email group was accessed. |
| CurrentStatus | String | False |
The current status of the email group. |
| Depth | String | False |
The depth of the email group. |
| UpdatedAt | Datetime | True |
Date the email group was updated. |
| UpdatedBy | String | True |
The Id of the user who last updated the email group. |