ODBC Driver for Oracle Service Cloud

Build 24.0.9060

AccountGroups

The language-specific strings used for localization of fields.

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 AccountGroups id = 12
SELECT * FROM AccountGroups id > 15
SELECT * FROM AccountGroups lookUpName LIKE '%test'
SELECT * FROM AccountGroups id IN (12, 23, 123)
SELECT * FROM AccountGroups lookUpName IS NOT NULL

INSERT

Insert can be executed by specifying the acceptCount,respondCount and names column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO AccountGroupsNames#TEMP (languageId, labeltext) VALUES ('1', 'Smartly Maestro')
INSERT INTO AccountGroups(LookupName, Name, names) VALUES ('test', 'test', AccountGroupsNames#TEMP)

UPDATE

Update can be executed. The columns that are not read-only can be Updated. For example:

UPDATE AccountGroups SET Name = 'SV100D' WHERE Id = 12

DELETE

Following is an example of how to Delete a record in this table. For example:

DELETE FROM AccountGroups WHERE Id = 12

Columns

Name Type ReadOnly Description
Id Long False

The unique identifier of the account group .

LookupName String False

The name used to look up the account group.

Name Long False

The name of the account group in the language of the current interface.

DisplayOrder Long False

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

UpdatedTime String False

The date and time when the account group was last updated.

CreatedTime String False

The date and time when the account group was created

AttributesCustomerCareAccess Boolean False

The customer care access group.

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

The list of descriptions, one for each supported language.

Names String

The list of names, one for each supported language.

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