Emails
Returns a list of email addresses of all constituents or a specified constituent
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.
- 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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| IncludeInactive | Boolean | If set to true, includes inactive email addresses in the result. |