JDBC Driver for Oracle Eloqua

Build 23.0.8839

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.

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