AnswersCommonAttachments
The file attachment shared by sibling answers.
Table-Specific Information
SELECT
The 本製品 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 本製品.
SELECT * FROM AnswersCommonAttachments WHERE id = 12 SELECT * FROM AnswersCommonAttachments WHERE id > 15 SELECT * FROM AnswersCommonAttachments WHERE filename LIKE '%test' SELECT * FROM AnswersCommonAttachments WHERE id IN (12, 23, 123) SELECT * FROM AnswersCommonAttachments 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. |
| 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 | |
| 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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| names | String | The list of language specific display names. |