ServiceDispositions
The hierarchical service disposition that provides an option for classifying and recording how incidents are ultimately resolved.
Table-Specific Information
SELECT
The connector 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 connector.
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. |