Phones
Returns a list of phones for all constituents or a specific 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.
- Id supports the '=' operator.
- ConstituentId supports the '=,in' operators.
- DateAdded supports the '>=' operators.
- DateModified supports the '>=' operators.
- IncludeInactive supports the '=' operators.
SELECT * FROM Phones WHERE Id = '1'
SELECT * FROM Phones WHERE ConstituentId IN ('280', '281')
SELECT * FROM Phones WHERE DateAdded >= '2010-06-01 14:03:35'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The immutable system record ID of the phone. | |
| ConstituentId | String |
Constituents.Id | The immutable system record ID of the constituent associated with the phone. |
| DateAdded | Datetime | The date when the phone was created. | |
| DateModified | Datetime | The date when the phone was last modified. | |
| DoNotCall | Boolean | Indicates whether the constituent requests not to be contacted at this number. | |
| Inactive | Boolean | Indicates whether the phone is inactive. | |
| Number | String | The phone number. | |
| Primary | Boolean | Indicates whether this is the constituent's primary phone. | |
| Type | String | The phone type. |
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 phones in the result. |