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 add-in 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 add-in.

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.

Excel Add-In for Oracle Service Cloud