StandardContents
The preformed text or HTML content that can be sent to customers when responding to incidents, appended to responses by a business rule, or sent by an agent during a chat session.
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 StandardContents WHERE id = 12 SELECT * FROM StandardContents WHERE id > 15 SELECT * FROM StandardContents WHERE lookUpName LIKE '%test' SELECT * FROM StandardContents WHERE id IN (12, 23, 123) SELECT * FROM StandardContents WHERE lookUpName IS NOT NULL
INSERT
Insert can be executed by specifying the contentValues,name and usage in WHERE Clause. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.
INSERT INTO standardContents (name, usagechattext) VALUES ('Battery Replacement', 'false')
UPDATE
Update can be executed by specifying the id column in WHERE Clause. The columns that are not read-only can be Updated.
For example:
UPDATE StandardContents SET folderid = '100146' WHERE id = '4'
DELETE
Delete can be executed by specifying id in the WHERE Clause.
For example:
DELETE FROM StandardContents WHERE id = '3'
Columns
Name | Type | ReadOnly | Description |
Comment | String | False |
The comments associated with the standard content object. |
CreatedTime | Datetime | True |
The date and time when the standard content was created. This attribute is read-only. |
DisplayOrder | Int | False |
The display position of the standard content relative to other standard content objects with the same parent. |
HotKey | String | False |
The assigned shortcut key for inserting the standard content. |
Id [KEY] | Long | True |
The unique identifier of the standard content object. |
LookupName | String | True |
The name used to look up the standard content object. |
Name | String | False |
The name of the standard content object. |
UpdatedTime | Datetime | True |
The date and time when the standard content was last updated. This attribute is read-only. |
AttributesdisplayRightToLeft | Bool | False |
Indicates whether the content presentation is from right to left. The default value is false. |
Folderid | Long | False |
ID value |
FolderlookupName | String | False |
Name used to lookup this object |
UsagechatText | Bool | False |
Indicates whether the content is used in a chat session. The default value is false. |
UsagechatURL | Bool | False |
Indicates whether the content is used in the URL of a chat session. The default value is false. |
UsageincidentText | Bool | False |
Indicates whether the content is used in an incident. The default value is false. |
UsageruleText | Bool | False |
Indicates whether the content is used in a rule. The default value is false. |
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. |
contentValues | String |
The list of the preformed content with entries for each content type. |