ConstituentsCustomFields

Retrieves custom fields for all constituents

Table Specific Information

Select

The 本製品 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 本製品. Note: Name is required when filtering with value.

Name supports the '=' operator.
Value supports the '=,IN' operators.
DateAdded supports the '>=,>' operators.
DateModified supports the '>=,>' operators.

For example:

	SELECT * FROM ConstituentsCustomFields WHERE Name = 'Business Hours'
	SELECT * FROM ConstituentsCustomFields WHERE Name = 'Business Hours' AND Value IN ('yes', '24 hours')
	SELECT * FROM ConstituentsCustomFields WHERE DateAdded > '2025-07-01T00:00:00'
	SELECT * FROM ConstituentsCustomFields WHERE DateModified >= '2025-08-01T00:00:00'

Columns


Name	Type	References	Description
Id	String		The immutable system record ID of the custom field.
ConstituentId	String		The parent object's immutable system record ID.
Name	String		The custom field category.
Value	String		The value of the custom field.
Comment	String		The comment on the custom field.
DateAdded	Datetime		The date when the custom field was created.
DateModified	Datetime		The date when the custom field was last modified.
Type	String		The type of data that the custom field represents.

Excel Add-In for Blackbaud Raisers Edge NXT

ConstituentsCustomFields

Table Specific Information

Select

Columns