EmailFolder
Retrieve Email Folders.
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 folder. |
| Name | String | The name of the folder. |
| IsSystem | Boolean | Identifies a system-generated folder. |
| Description | String | The description of the folder. |
| Permissions | String | The permissions of the folder. |
| CreatedAt | Datetime | Date the folder was created. |
| CreatedBy | String | The Id of the user who created the folder. |
| AccessedAt | Datetime | Date the folder was accessed. |
| CurrentStatus | String | The current status of the folder. |
| UpdatedAt | Datetime | Date the folder was last updated. |
| UpdatedBy | String | The Id of the user who last updated the folder. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Depth | String | The depth of information requested from Eloqua. |