ContactsChannelUsernames
The user name of the channel.
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 ContactsChannelUsernames WHERE contactsId = 12 SELECT * FROM ContactsChannelUsernames WHERE contactsId > 15 SELECT * FROM ContactsChannelUsernames WHERE usernumber LIKE '%test' SELECT * FROM ContactsChannelUsernames WHERE contactsId IN (12, 23, 123) SELECT * FROM ContactsChannelUsernames WHERE usernumber IS NOT NULL
Columns
| Name | Type | Description |
| ContactsId | Long | The unique identifier of the contact. |
| ChannelTypeId | Long | Id of channelType. The associated communication channel. This is the key for the list entry. |
| ChannelTypelookUpName | String | LookUpName of channelType. The associated communication channel. This is the key for the list entry. |
| UserNumber | String | The user number ID for this communication channel. It is a string with a value between 0 and 9. |
| Username | String | The user name for this communication channel. |