AnswerVersionsCommonAttachments
The file attachment shared by sibling 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 AnswerVersionsCommonAttachments WHERE id = 12 SELECT * FROM AnswerVersionsCommonAttachments WHERE id > 15 SELECT * FROM AnswerVersionsCommonAttachments WHERE filename LIKE '%test' SELECT * FROM AnswerVersionsCommonAttachments WHERE id IN (12,23,123) SELECT * FROM AnswerVersionsCommonAttachments WHERE filename IS NOT NULL
Columns
| Name | Type | Description |
| AnswerVersionsId | Long | Id of AnswerVersions. |
| 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. |
| Disabled | Bool | Indicates whether the file attachment is 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 form data. |
| Id [KEY] | Long | The unique identifier 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. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| names | String | The list of language specific display names. |