JDBC Driver for Blackbaud Raisers Edge NXT

Build 22.0.8462

OpportunityAttachments

Returns a list of attachments for an opportunity

Table Specific Information

Select

The driver will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the driver.
Note: OpportunityId is required in order to query OpportunityAttachments.

  • OpportunityId supports the '=' operator.
For example:
	SELECT * FROM OpportunityAttachments WHERE OpportunityId = '4'

Columns

Name Type References Description
Id [KEY] String The immutable system record ID of the attachment.
OpportunityId String

Opportunities.Id

The ID of the Opportunity.
Content_type String The content type. For physical attachments only.
Date Datetime The date of the attachment.
FileId String The identifier of the file.
FileName String The file name. For physical attachments only.
FileSize Integer The file size in bytes. For physical attachments only.
Name String The name of the attachment.
ParentId String The parent object's immutable system record ID.
Tags String The tags associated with the attachment.
ThumbnailId String The identifier of the thumbnail. For physical attachments that are images only.
ThumbnailUrl String The URL for a thumbnail.
Type String The attachment type. Available values are Link and Physical.
Url String The URL for the attachment.

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