JDBC Driver for Oracle Service Cloud

Build 22.0.8462

OpportunitiesQuotesFileAttachments

The file that is attached or associated with another object.

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 OpportunitiesQuotesFileAttachments WHERE id = 12
SELECT * FROM OpportunitiesQuotesFileAttachments WHERE id > 15
SELECT * FROM OpportunitiesQuotesFileAttachments WHERE fileName LIKE '%test'
SELECT * FROM OpportunitiesQuotesFileAttachments WHERE id IN (12,23,123)
SELECT * FROM OpportunitiesQuotesFileAttachments WHERE updatedTime IS NOT NULL

Columns

Name Type Description
OpportunitiesId Long The unique identifier of the opportunity.
QuotesId Long
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 object. 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.
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.
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