Notes
Returns a list of notes that tracks helpful or important details such as specific interests and special instructions for donations
Table Specific Information
Select
The connector 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 connector.
- Id supports the '=' operator.
- ConstituentId supports the '=' operator.
- DateAdded supports the '>=,>' operators.
- DateModified supports the '>=,>' operators.
SELECT * FROM Notes WHERE ConstituentId = '280' SELECT * FROM Notes WHERE DateAdded >= '2010-06-01 14:03:35'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The immutable system record ID of the note. | |
| ConstituentId | String |
Constituents.Id | The immutable system record ID of the constituent associated with the note. |
| DateD | Integer | The day of note date. | |
| DateM | Integer | The month of note date. | |
| DateY | Integer | The year of note date. | |
| DateAdded | Datetime | The date when the note was created. | |
| DateModified | Datetime | The date when the note was last modified. | |
| Summary | String | The note summary. | |
| Text | String | The note's contents. | |
| Type | String | The note type. |