IncidentsFileAttachments
The file attachment that includes fields specific to incidents.
Table-Specific Information
SELECT
The adapter will use the 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 adapter.
SELECT * FROM IncidentsFileAttachments WHERE id = 12 SELECT * FROM IncidentsFileAttachments WHERE id > 15 SELECT * FROM IncidentsFileAttachments WHERE filename LIKE '%test' SELECT * FROM IncidentsFileAttachments WHERE id IN (12, 23, 123) SELECT * FROM IncidentsFileAttachments WHERE filename IS NOT NULL
Columns
| Name | Type | Description |
| IncidentsId | Long | The unique identifier of the incident. |
| ContentType | String | 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 file was associated with the incident. This attribute is read-only. |
| Data | String | The Base64 encoded data contained in the file. The maximum supported length is defined by the maximum number of bytes allowed by this field. |
| Description | String | The description for the contents of the file attachment. |
| FileName | String | The name of the file when saving it to the disk. |
| FormData | String | The HTML form which is used to upload file attachments. |
| Id [KEY] | Long | The unique identifier of the file attachment. |
| Name | String | The short display name of the file attachment. |
| Private | Bool | Indicates whether the file attachment is hidden from the end users. This attribute does not have a default value. |
| Size | Int | The size of the file in bytes. This attribute is read-only. |
| URL | String | The URL to access this file. |
| UpdatedTime | Datetime | The date and time when the file was last updated. This attribute is read-only. |