SSIS Components for Oracle Service Cloud

Build 24.0.9060

AnswerVersions

The versioned instance of an answer. Answers are solutions to common customer support questions.

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

UPDATE

Update can be executed by specifying the id in WHERE Clause. The columns that are not read-only can be Updated. For example: 

UPDATE AnswerVersions SET keywords = 'test' WHERE id = 133

DELETE

Delete can be executed by specifying id in the WHERE Clause. For example: 

DELETE FROM AnswerVersions WHERE id = 133

Columns

Name Type ReadOnly Description
AdminLastAccessTime Datetime True

The date and time when the answer version was last accessed by an administrator. This attribute is read-only.

AnswerId Long True

Id of answer. The live answer related to this answer version.

AnswerlookUpName String True

LookUpName of answer. The live answer related to this answer version.

AnswerTypeId Long False

Id of answerType. The type of storage for answer version information.

AnswerTypelookUpName String False

LookUpName of answerType. The type of storage for answer version information.

CreatedTime Datetime True

The date and time when the answer version was created. This attribute is read-only.

ExpiresDate Date False

The date when the answer version expires and is set to review status.

GuidedAssistanceId Long True

Id of guidedAssistance. The Guided Assistance guide.

GuidedAssistancelookUpName String True

LookUpName of guidedAssistance. The Guided Assistance guide.

Id [KEY] Long True

The unique identifier of the answer version.

Keywords String False

The list of space separated keywords associated with an answer version.

LanguageId Long False

Id of language. The language used for the answer text.

LanguagelookUpName String False

LookUpName of language. The language used for the answer text.

LastAccessTime Datetime True

The date and time when the answer version was last accessed. This attribute is read-only.

LastNotificationTime Datetime True

The date and time when the last notification was generated. This attribute is read-only.

LookupName String True

The name used to look up the answer version.

Name String True

The string version of the answer ID, which is used as the reference number of the answer version. This attribute is read-only.

NextNotificationTime Datetime False

The date and time when the next notification will be sent.

OriginalReferenceNumber String False

The reference number of the incident that was proposed to create this answer. The reference number is common for all the sibling answers.

PositionInListId Long False

Id of positionInList. This attribute is used to initialize and/or force this answer to a particular ranking in the search results.

PositionInListlookUpName String False

LookUpName of positionInList. This attribute is used to initialize and/or force this answer to a particular ranking in the search results.

PublishOnDate Date False

The date when the answer version will be published and made available to users.

Question String False

The question or the description of the answer version.

Solution String False

The solution or the answer portion of this version of the answer.

SpecialResponse String False

The special response of this version of the answer.

Summary String False

The title or short summary of the answer version.

URL String False

The URL which returns this version of the answer, if the answer type is URL.

UpdatedByAccountId Long True

Id of updatedByAccount. The staff account who last edited the answer version. This attribute is read-only.

UpdatedByAccountlookUpName String True

LookUpName of updatedByAccount. The staff account who last edited the answer version. This attribute is read-only.

UpdatedTime Datetime True

The date and time when the answer version was last updated. This attribute is read-only.

AssignedToaccountId Long False

Id of account. The staff account.

AssignedToaccountlookUpName String False

LookUpName of account. The staff account.

AssignedTostaffGroupId Long False

Id of staffGroup. The staff group. The caller should assign the staff group when assigning to an account.

AssignedTostaffGrouplookUpName String False

LookUpName of staffGroup. The staff group. The caller should assign the staff group when assigning to an account.

BannerimportanceFlagId Long False

Id of importanceFlag. The importance of the banner.

BannerimportanceFlaglookUpName String False

LookUpName of importanceFlag. The importance of the banner.

Bannertext String False

The description of a flag.

BannerupdatedByAccountId Long True

Id of updatedByAccount. The staff account that most recently updated the banner flag and/or text. This attribute is read-only.

BannerupdatedByAccountlookUpName String True

LookUpName of updatedByAccount. The staff account that most recently updated the banner flag and/or text. This attribute is read-only.

BannerupdatedTime Datetime True

The date and time when the banner was last updated. This attribute is read-only.

StatusWithTypestatusId Long False

Id of status. The current status.

StatusWithTypestatuslookUpName String False

LookUpName of status. The current status.

StatusWithTypestatusTypeId Long True

Id of statusType. The associated status type. This attribute is read-only.

StatusWithTypestatusTypelookUpName String True

LookUpName of statusType. The associated status type. This attribute is read-only.

VersionDetaildraftNote String False

The draft note for the answer version.

VersionDetaildraftTime Datetime False

The date and time when the draft answer version was created.

VersionDetailpublishNote String False

The published note for the answer version.

VersionDetailpublishedTime Datetime False

The date and time when the draft answer version was published.

VersionDetailstateId Long False

Id of state. The state of the version.

VersionDetailstatelookUpName String False

LookUpName of state. The state of the version.

VersionDetailunpublishedTime Datetime False

The date and time when the answer version was unpublished.

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
categories String

The categories common to all sibling answers.

commonAttachments String

The file attachments common to all sibling answers.

fileAttachments String

The list of file attachments.

notes String

The list of discussion threads.

products String

The products common to all sibling answers.

relatedAnswers String

The related answers linked to this answer.

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