JDBC Driver for Oracle Service Cloud

Build 22.0.8462

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 driver 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 driver.

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462