ODBC Driver for Blackbaud Raisers Edge NXT

Build 24.0.9062

ConstituentFundraiserAssignments

Returns a list of fundraiser assignments for a constituent.

Table Specific Information

Select

The 本製品 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 本製品.
Note: ConstituentId is required in order to query ConstituentFundraiserAssignments.

  • ConstituentId supports the '=' operator.
  • IncludeInactive supports the '=' operator.
For example:
	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

FundraisingAppeals.Id

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062