ContactList
Create, update, delete, and query Contact Lists.
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 | Description |
| ID [KEY] | Long | The unique identifier for the contact list. |
| Name | String | The name of the contact list. |
| Count | String | The count of the contact list. |
| DataLookupId | String | The Id of the data lookup for the contact list. |
| MembershipAdditions | String | The number of contact membership additions in the contact list. |
| Scope | String | The contact list's scope: either local or global. |
| Description | String | The description of the contact list. |
| FolderId | Long | The Id of the folder for the contact list. |
| ScheduledFor | Datetime | The date and time scheduled for the contact list. |
| SourceTemplatedId | Long | The Id of the source template of the contact list. |
| Permissions | String | The permissions of the contact list. |
| CreatedAt | Datetime | Date the contact list was created. |
| CreatedBy | String | The Id of the user who created the contact list. |
| AccessedAt | Datetime | Date the contact list was accessed. |
| CurrentStatus | String | The current status of the contact list. |
| Depth | String | The depth of the contact list. |
| UpdatedAt | Datetime | Date the contact list was updated. |
| UpdatedBy | String | The Id of the user who created the contact list. |