User
Retrieve Users.
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 this user. |
| Name | String | The name of the user. |
| Company | String | The company of the user. |
| Capabilities | String | The capabilities of the user. |
| BetaAccess | String | The beta access flag for the user. |
| DefaultAccountViewId | Long | The Id of the default account view for the user. |
| DefaultContactViewId | Long | The Id of the default contact view for the user. |
| EmailAddress | String | The email address of the user. |
| LoggedInAt | String | When the user last logged in. |
| LoginName | String | The login name of the user. |
| Preferences | String | The preferences for the user. |
| ProductPermissions | String | The product permissions for the user. |
| TypePermissions | String | The type permissions for the user. |
| ScheduledFor | Datetime | The date and time scheduled for the user. |
| SourceTemplatedId | Long | The Id of the source template for the user. |
| Description | String | The description of the user. |
| FolderId | Long | The Id of the folder for the user. |
| Permissions | String | The permissions of the user. |
| CreatedAt | Datetime | Date the user was created. |
| CreatedBy | String | The Id of the user that created the user. |
| AccessedAt | Datetime | Date the user was accessed. |
| CurrentStatus | String | The current status of the user. |
| Depth | String | The depth of the user. |
| UpdatedAt | Datetime | Date the user was updated. |
| UpdatedBy | String | The Id of the user who last updated the user. |