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.
SELECT * FROM ProjectAttachments WHERE ProjectId = 1
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 |