JDBC Driver for Oracle Service Cloud

Build 22.0.8462

IncidentsThreads

The incident discussion thread entry.

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 IncidentsThreads WHERE id = 12
SELECT * FROM IncidentsThreads WHERE id > 15
SELECT * FROM IncidentsThreads WHERE text LIKE '%test'
SELECT * FROM IncidentsThreads WHERE id IN (12,23,123)
SELECT * FROM IncidentsThreads WHERE text IS NOT NULL

Columns

Name Type Description
IncidentsId Long The unique identifier of the incident.
AccountId Long Id of account. The associated staff account. This attribute is read-only.
AccountlookUpName String LookUpName of account. The associated staff account. This attribute is read-only.
ChannelId Long Id of channel. The associated communication channel.
ChannellookUpName String LookUpName of channel. The associated communication channel.
ContactId Long Id of contact. The associated contact.
ContactlookUpName String LookUpName of contact. The associated contact.
ContentTypeId Long Id of contentType. The MIME content type of the file. For example, text/plain, audio/mp3, image/jpg, and so on.
ContentTypelookUpName String LookUpName of contentType. The MIME content type of the file. For example, text/plain, audio/mp3, image/jpg, and so on.
CreatedTime Datetime The date and time when the thread was created. This attribute is read-only.
DisplayOrder Int The relative display order for the threads with the same created time. This attribute is read-only.
EntryTypeId Long Id of entryType. The entry type.
EntryTypelookUpName String LookUpName of entryType. The entry type.
Id [KEY] Long The unique identifier of the thread. It cannot be used for delete operations.
MailHeader String The mail header information for a contact submitting the thread by email.
Text String The entry text in the thread.

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