ChannelTypes
The social channels tracked in contact records when storing social account user names and associating social monitor incidents to contacts.
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 ChannelTypes WHERE Id = 12 SELECT * FROM ChannelTypes WHERE Id > 15 SELECT * FROM ChannelTypes WHERE lookUpName LIKE '%test' SELECT * FROM ChannelTypes WHERE Id IN (12, 23, 123) SELECT * FROM ChannelTypes WHERE lookUpName IS NOT NULL
Columns
| Name | Type | Description |
| ContactVisibility | Bool | Indicates whether the channel is available in the ChannelUsername collection. This attribute does not have a default value and is read-only. |
| CreatedTime | Datetime | The date and time when the channel type was created. This attribute is read-only. |
| DisplayOrder | Int | The position of the channel type in the list of channels. |
| Id [KEY] | Long | The unique identifier of the channel type. |
| LookupName | String | The name used to look up the channel type. |
| Name | String | The name of the channel type in the language of the current interface. This attribute is read-only. |
| UpdatedTime | Datetime | The date and time when the channel type was last updated. This attribute is read-only. |
| AttributescontactVisibility | Bool | Indicates whether the channel is visible to contacts. This attribute does not have a default value. |
| Attributesincoming | Bool | Indicates whether it is an incoming channel. This attribute does not have a default value. |
| Attributesmonitoring | Bool | Indicates whether it is a monitoring channel. This attribute does not have a default value. |
| Attributesoutgoing | Bool | Indicates whether it is an outgoing channel. This attribute does not have a default value. |
| Attributessubscription | Bool | Indicates whether it is a subscription channel. This attribute does not have a default value. |
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 |
| names | String | The list of names, one for each supported language. |