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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| IncludeInactive | Boolean | If set to true, includes inactive phones in the result. |