ODBC Driver for Blackbaud Raisers Edge NXT

Build 24.0.9062

ActionAttachments

Retrieves a list of attachments for an action.

Table Specific Information

Select

The 本製品 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 本製品.
Note: ActionId is required in order to query ActionAttachments.

  • ActionId supports the '=' operator.
For example:
	SELECT * FROM ActionAttachments WHERE ActionId = '335'

Columns

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

Actions.Id

The immutable system record ID of the action this attachment is associated to.
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 Long 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 parent object's immutable system record ID.
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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062