ConstituentAttachments
Returns a list of attachments for a constituent.
Table Specific Information
Select
The add-in 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 add-in.
Note: ConstituentId is required in order to query ConstituentAttachments.
- ConstituentId supports the '=' operator.
SELECT * FROM ConstituentAttachments WHERE ConstituentId = '280'
Columns
Name | Type | References | Description |
Id [KEY] | String | The immutable system record ID of the attachment. | |
ConstituentId | String | The immutable system record ID of the constituent associated with the attachment. | |
ContentType | String | The content type. | |
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. | |
Type | String | The attachment type. | |
Url | String | The URL for the attachment. |