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 connector 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 connector.
- 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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| IncludeInactive | Boolean | If set to true, includes inactive packages in the response. |