JDBC Driver for Oracle Service Cloud

Build 22.0.8462

Chats

The real-time, two-way dialog between a customer and one or more chat agents.

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

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