JDBC Driver for Blackbaud Raisers Edge NXT

Build 22.0.8462

CampaignAttachments

Returns a list of attachments for a campaign.

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: CampaignId is required in order to query CampaignAttachments.

  • CampaignId supports the '=' operator.
For example:
	SELECT * FROM CampaignAttachments WHERE CampaignId = '2'

Columns

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

Campaigns.Id

The immutable system record ID of the campaign.
ContentType 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.
FileSize Integer The file size in bytes.
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.
ThumbnailUrl String The URL for a thumbnail.
Type String The attachment type.
Url String The URL for the attachment.

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