JDBC Driver for Blackbaud Raisers Edge NXT

Build 22.0.8462

FundraiserAssignments

Returns a list of assignments for a fundraiser.

Table Specific Information

Select

The driver 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 driver.
Note: FundraiserId is required in order to query FundraiserAssignments.

  • FundraiserId supports the '=' operator.
For example:
	SELECT * FROM FundraiserAssignments WHERE FundraiserId = '4'
	

Columns

Name Type References Description
Id String The immutable system record ID of the given 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 target constituent.
End Datetime The fundraiser 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 assigned to the constituent.
Start Date The fundraiser start date.
Type String The type of fundraiser.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462