ProjectNotes
Returns the list of notes for the specified project.
The connector 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 connector.
- ProjectId supports the '=' operator.
SELECT * FROM ProjectNotes WHERE ProjectId = 1
Columns
| Name | Type | References | Description |
| ProjectId [KEY] | Integer | The identifier of the project. | |
| NoteActionId [KEY] | Integer | The note action identifier. | |
| NoteType | String | The note type. | |
| Type | String | The action type. | |
| Date | Datetime | The date of the note action. | |
| Content | String | The content of the note. | |
| Description | String | The description of the note action. | |
| IsComplete | Boolean | Whether the note action is complete. | |
| AssignTo | String | Who the note action is assigned to. | |
| CompletedDate | Datetime | The date the note action was completed. |