AnswersFileAttachments
The file attachment shared by answers.
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 AnswersFileAttachments WHERE id = 12 SELECT * FROM AnswersFileAttachments WHERE id > 15 SELECT * FROM AnswersFileAttachments WHERE filename LIKE '%test' SELECT * FROM AnswersFileAttachments WHERE id IN (12,23,123) SELECT * FROM AnswersFileAttachments WHERE filename IS NOT NULL
Columns
| Name | Type | Description |
| AnswersId | Long | Id of Answers. |
| 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 answer. 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. |
| Disabled | Bool | Indicates whether the file attachment should be hidden when the associated answer is viewed. If the Private flag is not set, this flag hides the file attachment. This attribute does not have a default value. |
| 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. |
| Indexed | Bool | Indicates whether the file attachment's contents are included in the keyword indexing of the answer. This attribute does not have a default value. |
| Name | String | The short display name of the file attachment. |
| Private | Bool | Indicates whether the file attachment is hidden from the end users. The default value is false. |
| Size | Int | The size of the file in bytes. This attribute is read-only. |
| URL | String | The URL to access the file. |
| UpdatedTime | Datetime | The date and time when the file was last updated. This attribute is read-only. |