ODBC Driver for Blackbaud Raisers Edge NXT

Build 24.0.9062

Emails

Returns a list of email addresses of all constituents or a specified constituent.

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 本製品.

  • ConstituentId supports the '=,in' operators.
  • DateAdded supports the '>=,>' operators.
  • DateModified supports the '>=,>' operators.
  • IncludeInactive supports "=" operator.
For example:
	
	SELECT * FROM Emails WHERE ConstituentId = '280'
	
	SELECT * FROM Emails WHERE DateAdded >= '2010-06-01 14:03:35'

Columns

Name Type References Description
Id [KEY] String The immutable system record ID of the email address.
Address String The email address.
ConstituentId String

Constituents.Id

The immutable system record ID of the constituent associated with the email address.
DateAdded Datetime The date when the email address was created.
DateModified Datetime The date when the email address was last modified.
DoNotEmail Boolean Indicates whether the constituent requests not to be contacted at this email address.
Inactive Boolean Indicates whether the email address is inactive.
Primary Boolean Indicates whether this is the constituent's primary email address.
Type String The type of email address.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
IncludeInactive Boolean If set to true, includes inactive email addresses in the result.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062