ConstituentFundraiserAssignments
Returns a list of fundraiser assignments for a 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.
Note: ConstituentId is required in order to query ConstituentFundraiserAssignments.
- ConstituentId supports the '=' operator.
- IncludeInactive supports the '=' operator.
SELECT * FROM ConstituentFundraiserAssignments WHERE ConstituentId = '280'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The immutable system record ID of the fundraiser assignment. | |
| AmountValue | Double | The goal amount for the fundraiser to solicit from the assigned constituent. | |
| AppealId | String | The immutable system record ID of the appeal the fundraiser should use to request gifts. | |
| CampaignId | String |
Campaigns.Id | The immutable system record ID of the campaign to apply resulting gifts to. |
| ConstituentId | String |
Constituents.Id | The immutable system record ID of the constituent to apply resulting gifts to. |
| End | Datetime | The fundraiser assignment end date. | |
| FundId | String |
Funds.Id | The immutable system record ID of the fund any resulting gifts should be applied to. |
| FundraiserId | String | The immutable system record ID of the fundraiser. | |
| Start | Datetime | The fundraiser assignment start date. | |
| Type | String | The type of fundraiser. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| IncludeInactive | Boolean | If set to true, includes inactive assignments in the result. |