JDBC Driver for Oracle Service Cloud

Build 22.0.8462

AnswersCategories

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

Columns

Name Type Description
CategoriesId [KEY] Long The unique identifier of the object. This is the key for the list entry.
CategoriesLookUpName String The name used to look up the object.
AnswersId Long The unique identifier of the object. This is the key for the list entry.
AnswersLookUpName String The name used to look up the object.

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