SSIS Components for Oracle Service Cloud

Build 24.0.9060

AnswerVersionsRelatedAnswers

The link to related answers.

Table-Specific Information

SELECT

The component 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 component.

SELECT * FROM AnswerVersionsRelatedAnswers WHERE manualstrength = 12
SELECT * FROM AnswerVersionsRelatedAnswers WHERE manualstrength > 15
SELECT * FROM AnswerVersionsRelatedAnswers WHERE toanswerlookUpName LIKE '%test'
SELECT * FROM AnswerVersionsRelatedAnswers WHERE manualstrength IN (12, 23, 123)
SELECT * FROM AnswerVersionsRelatedAnswers WHERE toanswerlookUpName IS NOT NULL

Columns

Name Type Description
AnswerVersionsId Long The unique identifier of the answer version.
LearnedStrength Int The relative relatedness of the linked answers.
ManualStrength Int The static strength of the link.
SimilarityStrength Int The strength of the link calculated by the link-clustering algorithms based on the content similarity of the answers.
ToAnswerId Long Id of toAnswer. The answer to which this answer is linked. It is usually an answer that was viewed after this answer. This is the key for the list entry.
ToAnswerlookUpName String LookUpName of toAnswer. The answer to which this answer is linked. It is usually an answer that was viewed after this answer. This is the key for the list entry.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060