Chats
The real-time, two-way dialog between a customer and one or more chat agents.
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 Chats WHERE id = 12 SELECT * FROM Chats WHERE id > 15 SELECT * FROM Chats WHERE lookUpName LIKE '%test' SELECT * FROM Chats WHERE id IN (12, 23, 123) SELECT * FROM Chats WHERE lookUpName IS NOT NULL
Columns
| Name | Type | Description |
| CreatedTime | Datetime | The date and time when the chat was created. This attribute is read-only. |
| Id [KEY] | Long | The unique identifier of the chat. |
| LookupName | String | The name used to look up the chat. |
| Question | String | The question that is used as the lookupName for the chat object. |
| UpdatedTime | Datetime | The date and time when the chat was last updated. This attribute is read-only. |