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.
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 | 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. |