JDBC Driver for Oracle Service Cloud

Build 22.0.8462

ServiceDispositions

The hierarchical service disposition that provides an option for classifying and recording how incidents are ultimately resolved.

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

INSERT

Insert can be executed by specifying the 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 ServiceDispositionsNames#TEMP (serviceDispositionsId,labeltext) VALUES ('16','Agent: Knowledge')
INSERT INTO ServiceDispositions (names) VALUES ('serviceDispositionsNames#TEMP')

UPDATE

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

UPDATE ServiceDispositions SET displayOrder = '1' WHERE lookupName = 'Product: Misuse'

DELETE

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

DELETE FROM ServiceDispositions WHERE lookupName = 'abc'

Columns

Name Type ReadOnly Description
CreatedTime Datetime True

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

DisplayOrder Int False

The display position of the service disposition relative to other dispositions with the same parent.

Id [KEY] Long True

The unique identifier of the service disposition.

LookupName String True

The name used to look up the service disposition.

Name String True

The name of the service disposition in the language of the current interface. This attribute is read-only.

ParentId Long False

Id of parent. The parent disposition in the hierarchy.

ParentlookUpName String False

LookUpName of parent. The parent disposition in the hierarchy.

UpdatedTime Datetime True

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

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

The list of interfaces on which the disposition is available for administration use.

descriptions String

The list of descriptions, one for each supported language.

names String

The list of names, one for each supported language.

productLinks String

The disposition to product linking.

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