JDBC Driver for Oracle Service Cloud

Build 22.0.8462

Accounts

The account represents a staff member in Oracle B2C Service.

Table-Specific Information

SELECT

The driver will use the Oracle Service Cloud API to process WHERE clause conditions built with =,!=,<,>,<=,>=,IN,NOT_IN,IS,IS_NOT,LIKE operators. The rest of the filters are executed client side within the driver.

SELECT * FROM Accounts WHERE id = 12
SELECT * FROM Accounts WHERE id > 15
SELECT * FROM Accounts WHERE lookUpName LIKE '%test'
SELECT * FROM Accounts WHERE id IN (12,23,123)
SELECT * FROM Accounts WHERE lookUpName IS NOT NULL

INSERT

Insert can be executed by specifying the login,namefirst,namelast,profileId,staffGroupId and newpassword columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO Accounts (login,namefirst,namelast,profileId,staffGroupId,newpassword) VALUES ('testadministrator','abc','xyz','14','102243','testpw')

UPDATE

Update can be executed by specifying the id in WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Accounts SET namelast = 'abcd' WHERE id = 1

DELETE

Delete can be executed by specifying id in the WHERE Clause. For example:

DELETE FROM Accounts WHERE id = '4'

Columns

Name Type ReadOnly Description
CountryId Long False

Id of country. The default country identifier.

CountrylookUpName String False

LookUpName of country. The default country identifier.

CreatedTime Datetime True

The date and time when the account was created. This attribute is read-only.

DisplayName String False

The display name of the account.

DisplayOrder Int False

The order in which this staff account is displayed relative to other members of the same group.

EmailNotificationId Long False

Id of emailNotification. The format the staff member prefers for email notifications.

EmailNotificationlookUpName String False

LookUpName of emailNotification. The format the staff member prefers for email notifications.

Id [KEY] Long True

The unique identifier of the account.

Login String False

The user name used for authentication.

LookupName String True

The name used to look up the account.

ManagerId Long False

Id of manager. The manager of the staff member.

ManagerlookUpName String False

LookUpName of manager. The manager of the staff member.

NewPassword String False

The new password for authentication. It is stored with a one-way encryption in the system. This attribute is write-only.

NotificationPending Bool True

Indicates whether any notifications are pending. This attribute does not have a default value and is read-only.

PasswordExpirationTime Datetime True

The date and time when the password is set to expire. This attribute is read-only.

ProfileId Long False

Id of profile. The profile to which the staff account is assigned.

ProfilelookUpName String False

LookUpName of profile. The profile to which the staff account is assigned.

Signature String False

The email signature of the account.

StaffGroupId Long False

Id of staffGroup. The group to which the staff member is assigned.

StaffGrouplookUpName String False

LookUpName of staffGroup. The group to which the staff member is assigned.

UpdatedTime Datetime True

The date and time when the account was last updated. This attribute is read-only.

AttributesaccountLocked Bool False

Indicates whether the account is temporarily locked. For example, you may lock a staff member's account who has taken a leave of absence. An account automatically gets locked if the staff member has exceeded the number of invalid login attempts or if the password has expired. The default value is false.

AttributescanModifyEmailSignature Bool False

Indicates whether the staff member can modify the email signature. The default value is false.

AttributesforcePasswordChange Bool False

Indicates whether the staff member must change the password at the next login. The value remains true until the staff member changes the password. The default value is false.

AttributesinfrequentUser Bool False

Indicates whether the staff member is considered as an infrequent user seat, as opposed to a full seat. The default value is false.

AttributespasswordNeverExpires Bool False

Indicates whether the staff member's account password never expires. This setting overrides system-wide password expiration configurations. The default value is false.

AttributespermanentlyDisabled Bool False

Indicates whether the staff member's account is permanently disabled. For example, an account is permanently disabled when a staff member leaves your organization. A disabled account appears in the tree of the Staff Accounts management console if Show Disabled setting is enabled, but you cannot deselect the Permanently Disable check box if you edit the account. You can reuse the login name of a permanently disabled account for a different account. The default value is false.

AttributesstaffAssignmentDisabled Bool False

Indicates whether the staff member's account cannot be assigned to incidents, answers, opportunities, and tasks. The default value is false.

AttributesviewsReportsDisabled Bool False

Indicates whether the staff member's account cannot be included in the list for filters in reports. The default value is false.

AttributesvirtualAccount Bool True

Indicates whether the staff member's account is virtual. The default value is false. This attribute is read-only.

Namefirst String False

The first name of the person.

Namelast String False

The surname or last name of the person.

NameFuriganafirst String False

The first name of the person.

NameFuriganalast String False

The surname or last name of the person.

SalesSettingsdefaultCurrencyId Long False

Id of defaultCurrency. The default currency ID.

SalesSettingsdefaultCurrencylookUpName String False

LookUpName of defaultCurrency. The default currency ID.

SalesSettingsterritoryId Long False

Id of territory. The sales territory ID.

SalesSettingsterritorylookUpName String False

LookUpName of territory. The sales territory ID.

ServiceSettingsscreenPopPort Int False

The port number assigned for screen-pop alerts for the staff account. It is used in Citrix and Terminal Services environments where there are multiple agents logged in to different sessions on the same machine.

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
emails String

The list of email addresses.

phones String

The list of phone numbers.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462