ServiceProducts
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 ServiceProducts WHERE id = 12 SELECT * FROM ServiceProducts WHERE id > 15 SELECT * FROM ServiceProducts WHERE lookUpName LIKE '%test' SELECT * FROM ServiceProducts WHERE id IN (12, 23, 123) SELECT * FROM ServiceProducts WHERE lookUpName IS NOT NULL
INSERT
Insert can be executed by specifying the names column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.
INSERT INTO ServiceProductsNames#TEMP (languageId, labeltext) VALUES ('1', 'Community Ideas') INSERT INTO ServiceProducts (names) VALUES ('serviceProductsNames#TEMP')
UPDATE
Update can be executed. The columns that are not read-only can be Updated.
For example:
UPDATE ServiceProducts SET displayOrder = '4' WHERE parentlookUpName IS NULL
DELETE
Delete can be executed by specifying id in the WHERE Clause.
For example:
DELETE FROM ServiceProducts WHERE id = '4'
Columns
Name | Type | ReadOnly | Description |
CreatedTime | Datetime | True |
The date and time when the service product was created. This attribute is read-only. |
DisplayOrder | Int | False |
The display position of the service product relative to other products with the same parent. |
Id [KEY] | Long | True |
The unique identifier of the service product. |
LookupName | String | True |
The name used to look up the service product. |
Name | String | True |
The name of the service product in the language of the current interface. |
ParentId | Long | False |
Id of parent. The parent product in the hierarchy. |
ParentlookUpName | String | False |
LookUpName of parent. The parent product in the hierarchy. |
UpdatedTime | Datetime | True |
The date and time when the service product was last updated. This attribute is read-only. |
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 |
adminVisibleInterfaces | String |
The list of interfaces on which the category is available for administration use. |
categoryLinks | String |
The product to category linking. |
descriptions | String |
The list of descriptions, one for each supported language. |
dispositionLinks | String |
The product to disposition linking. |
endUserVisibleInterfaces | String |
The list of interfaces on which the category is available for end user use. |
names | String |
The list of names, one for each supported language. |