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