ServiceCategoriesProductLinks
The product linking for a category or a disposition.
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 ServiceCategoriesProductLinks WHERE serviceproductId = 12 SELECT * FROM ServiceCategoriesProductLinks WHERE serviceproductId > 15 SELECT * FROM ServiceCategoriesProductLinks WHERE serviceproductlookUpName LIKE '%test' SELECT * FROM ServiceCategoriesProductLinks WHERE serviceproductId IN (12, 23, 123) SELECT * FROM ServiceCategoriesProductLinks WHERE serviceproductlookUpName IS NOT NULL
Columns
| Name | Type | Description |
| ServiceCategoriesId | Long | Id of ServiceCategories. |
| ServiceProductId | Long | Id of serviceProduct. The ID of the service product. This is the key for the list entry. |
| ServiceProductlookUpName | String | LookUpName of serviceProduct. The ID of the service product. This is the key for the list entry. |