ODBC Driver for Blackbaud Raisers Edge NXT

Build 24.0.9062

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 本製品 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 本製品.

  • 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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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

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