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