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