JDBC Driver for Blackbaud Raisers Edge NXT

Build 22.0.8462

Packages

Returns a list of packages that contains content and other items for the appeals that organizations use to solicit gifts

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.

  • Id supports the '=' operator.
  • AppealId supports the '=,in' operators.
  • DateAdded supports the '>=,>' operators.
  • DateModified supports the '>=,>' operators.
  • IncludeInactive supports the '=' operator.
For example:
	
	SELECT * FROM Packages WHERE Id = '1'
	
	SELECT * FROM Packages WHERE AppealId IN ('17', '18')
	
	SELECT * FROM Packages WHERE DateAdded >= '1999-06-01 14:03:35'

Columns

Name Type References Description
Id [KEY] String The immutable system record ID of the package.
AppealId String

FundraisingAppeals.Id

The immutable system record ID of the appeal associated with this package.
Category String The category of the package.
DateAdded Datetime The date when the package was created.
DateModified Datetime The date when the package was last modified.
DefaultGiftAmountValue Double The default amount for gifts associated with this package.
Description String The display name of the package.
End Datetime The end date of the package.
GoalValue Double The goal of this package.
Inactive Boolean This computed field indicates that the package is active if the current date is after any start and before any end.
LookupId String The user-defined identifier for the package.
Notes String The notes on the package.
RecipientCount Integer The amount of recipients of the package.
Start Datetime The start date of the package.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
IncludeInactive Boolean If set to true, includes inactive packages in the response.

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