ODBC Driver for Blackbaud Financial Edge NXT

Build 20.0.7587

ProjectAttachments

Returns the list of attachments for the specified project.

The driver will use the Blackbaud Financial Edge NXT API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.

  • ProjectId supports the '=' operator. This column is required to fetch the project attachments.
For example, the following queries are processed server side:
SELECT * FROM ProjectAttachments WHERE ProjectId = 1
You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will result in unfiltered data being pushed.

Columns

Name Type References Description
Id Integer The attachment identifier
ProjectId Integer The identifier for the project to retrieve the attachments for
Name String The name of this attachment
Url String The URL of this attachment
Type String The attachment type. Available values are Link and Physical
MediaType String User-defined category of this attachment
DateAttached Datetime The date the attachment was added

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587