JDBC Driver for Oracle Service Cloud

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462