Variables
A shortcut defined for a larger string that can be inserted in the body of an answer or inserted inline during a chat session.
Table-Specific Information
SELECT
The add-in 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 add-in.
SELECT * FROM Variables WHERE id = 12 SELECT * FROM Variables WHERE id > 15 SELECT * FROM Variables WHERE lookUpName LIKE '%test' SELECT * FROM Variables WHERE id IN (12, 23, 123) SELECT * FROM Variables WHERE lookUpName IS NOT NULL
INSERT
INSERT can be executed by specifying the name 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 Variables (name) VALUES ('Exampleinsertname')
UPDATE
Update can be executed. The columns that are not read-only can be Updated.
For example:
UPDATE Variables SET folderlookupName = 'variables' WHERE name = 'Exampleinsertname'
DELETE
Following is an example of how to Delete a record in this table.
For example:
DELETE FROM variables WHERE id = '3'
Columns
| Name | Type | ReadOnly | Description |
| CreatedTime | Datetime | True |
The date and time when the variable was created. This attribute is read-only. |
| DisplayOrder | Int | False |
The position of the variable in the variable list. |
| Id [KEY] | Long | True |
The unique identifier of the variable. |
| LookupName | String | True |
The name used to look up the variable. |
| Name | String | False |
The name of the variable. |
| SearchIndexable | Bool | False |
Indicates whether the text is indexed for searching the customer portal. The default value is false. |
| UpdatedTime | Datetime | True |
The date and time when the variable was last updated. This attribute is read-only. |
| Folderid | Long | False |
ID value |
| FolderlookupName | String | False |
Name used to lookup this object |
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 |
| interfaceValues | String |
The list of values, one for each supported interface. |