ServiceProductsCategoryLinks
The category linking for a product.
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 ServiceProductsCategoryLinks WHERE servicecategoryId = 12 SELECT * FROM ServiceProductsCategoryLinks WHERE servicecategoryId > 15 SELECT * FROM ServiceProductsCategoryLinks WHERE servicecategorylookUpName LIKE '%test' SELECT * FROM ServiceProductsCategoryLinks WHERE servicecategoryId IN (12, 23, 123) SELECT * FROM ServiceProductsCategoryLinks WHERE servicecategorylookUpName IS NOT NULL
Columns
Name | Type | Description |
ServiceProductsId | Long | Id of serviceProducts. |
ServiceCategoryId | Long | Id of serviceCategory. The ID of the service category. This is the key for the list entry. |
ServiceCategorylookUpName | String | LookUpName of serviceCategory. The ID of the service category. This is the key for the list entry. |