IncidentsThreads
The incident discussion thread entry.
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 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. |