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 driver 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 driver.

Id supports the '=' operator.
ConstituentId supports the '=' operator.
DateAdded supports the '>=,>' operators.
DateModified supports the '>=,>' operators.

For example:

	
	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.

JDBC Driver for Blackbaud Raisers Edge NXT

Notes

Table Specific Information

Select

Columns