OnlinePresences
Returns a paginated list of online presences that store a constituent's social media accounts, websites.
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 '=' operator.
- DateAdded supports the '>=,>' operators.
- DateModified supports the '>=,>' operators.
- IncludeInactive supports the '=' operator.
SELECT * FROM OnlinePresences WHERE ConstituentId = '280' SELECT * FROM OnlinePresences WHERE DateAdded >= '2010-06-01 14:03:35' SELECT * FROM OnlinePresences WHERE IncludeInactive = true
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The immutable system record ID of the online presence. | |
| Address | String | The web address for the online presence. | |
| ConstituentId | String |
Constituents.Id | The immutable system record ID of the constituent associated with the online presence. |
| DateAdded | Datetime | The date when the online presence was created. | |
| DateModified | Datetime | The date when the online presence was last modified. | |
| Inactive | Boolean | Indicates whether the online presence is inactive. | |
| Primary | Boolean | Indicates whether this is the constituent's primary online presence. | |
| Type | String | The online presence type. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| IncludeInactive | Boolean | If set to true, includes inactive online presences in the result. |