Tableau Connector for Oracle Service Cloud

Build 24.0.9060

Answers

The knowledge base information that provides solutions to the common customer support questions.

Table-Specific Information

SELECT

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

SELECT * FROM Answers WHERE id = 12
SELECT * FROM Answers WHERE id > 15
SELECT * FROM Answers WHERE lookUpName LIKE '%test'
SELECT * FROM Answers WHERE id IN (12, 23, 123)
SELECT * FROM Answers WHERE lookUpName IS NOT NULL

INSERT

Insert can be executed by specifying the answerTypeId, languageId, and summary newpassword columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table. 

INSERT INTO Answers (answerTypeId, languageId, assignedsiblingId, summary) VALUES ('1', '1', '12', 'How do I register my product?')

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 Answers SET solution = 'editorContent' WHERE id = '12'

DELETE

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

DELETE FROM Answers WHERE id = '4'

Columns

Name Type ReadOnly Description
AdminLastAccessTime Datetime True

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

AnswerTypeId Long False

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

AnswerTypelookUpName String False

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

AnswerVersionId Long True

Id of answerVersion. The versioned instance of the answer. This attribute is read-only.

AnswerVersionlookUpName String True

LookUpName of answerVersion. The versioned instance of the answer. This attribute is read-only.

AssignedSiblingId Long False

Id of assignedSibling. Another answer with which this answer should be associated.

AssignedSiblinglookUpName String False

LookUpName of assignedSibling. Another answer with which this answer should be associated.

CreatedTime Datetime True

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

ExpiresDate Date False

The date when the answer 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.

Keywords String False

The list of space separated keywords associated with an answer.

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

Name String True

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

NextNotificationTime Datetime False

The date and time when the next earliest 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 will be published and made available to users.

Question String False

The question or the description of the answer.

Solution String False

The solution or the answer portion of the answer.

SpecialResponse String False

The special response of the answer.

Summary String False

The title or short summary of the answer.

URL String False

The URL which returns the answer, if the answer type is URL.

UpdatedByAccountId Long True

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

UpdatedByAccountlookUpName String True

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

UpdatedTime Datetime True

The date and time when the answer 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 hierarchical service category.

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.

siblingAnswers String

The sibling answers with which this answer is associated. This attribute is read-only.

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