ServiceCategories
The hierarchical service category that provides an option to group answers and incidents for better organization and refined searching in the knowledge base.
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 ServiceCategories WHERE id = 12 SELECT * FROM ServiceCategories WHERE id > 15 SELECT * FROM ServiceCategories WHERE lookUpName LIKE '%test' SELECT * FROM ServiceCategories WHERE id IN (12, 23, 123) SELECT * FROM ServiceCategories 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 ServiceCategoriesNames#TEMP (languageId, labeltext) VALUES ('1', 'Community Ideas') INSERT INTO serviceCategories (names) VALUES ('ServiceCategoriesNames#TEMP')
UPDATE
Update can be executed. The columns that are not read-only can be Updated.
For example:
UPDATE ServiceCategories SET displayOrder = '1' WHERE ParentlookUpName = 'Ordering'
DELETE
Delete can be executed by specifying id in the WHERE Clause.
DELETE FROM ServiceCategories WHERE id = '83'
Columns
Name | Type | ReadOnly | Description |
CreatedTime | Datetime | True |
The date and time when the service category was created. This attribute is read-only. |
DisplayOrder | Int | False |
The display position of the service category relative to other categories with the same parent. |
Id [KEY] | Long | True |
The unique identifier of the service category. |
LookupName | String | True |
The name used to look up the service category. |
Name | String | True |
The name of the service category in the language of the current interface. This attribute is read-only. |
ParentId | Long | False |
Id of parent. The parent category in the hierarchy. |
ParentlookUpName | String | False |
LookUpName of parent. The parent category in the hierarchy. |
UpdatedTime | Datetime | True |
The date and time when the service category 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 category is available for administration use. |
descriptions | String |
The list of descriptions, one for each supported language. |
endUserVisibleInterfaces | String |
The list of interfaces on which the category is available for end user use. |
names | String |
The list of names, one for each supported language. |
productLinks | String |
The category to product linking. |