SSIS Components for Oracle Service Cloud

Build 24.0.9062

AnswersProducts

The hierarchical service product that provides an option to group answers and incidents for better organization and refined searching in the knowledge base.

Table-Specific Information

SELECT

The 本製品 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 本製品.

SELECT * FROM AnswersProducts WHERE answersId = 12
SELECT * FROM AnswersProducts WHERE answersId > 15
SELECT * FROM AnswersProducts WHERE answerslookUpName LIKE '%test'
SELECT * FROM AnswersProducts WHERE answersId IN (12, 23, 123)
SELECT * FROM AnswersProducts WHERE answerslookUpName IS NOT NULL

Columns

Name Type Description
ProductsId [KEY] Long The unique identifier of the object. This is the key for the list entry.
ProductsLookUpName 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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062