Emails
Returns a list of email addresses of all constituents or a specified constituent.
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.
- ConstituentId supports the '=,in' operators.
- DateAdded supports the '>=,>' operators.
- DateModified supports the '>=,>' operators.
- IncludeInactive supports "=" operator.
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. |