NXTAppeals
Returns a list of appeals.
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 '=' operator.
- IncludeInactive supports the '=' operator.
SELECT * FROM NXTAppeals WHERE AppealId = 'ANN2018' SELECT * FROM NXTAppeals WHERE IncludeInactive = true
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | The immutable system record ID of the appeal. | |
| AppealId | String | The user-defined identifier for the appeal. | |
| Description | String | The appeal description. | |
| AppealCategory | String | The appeal category name. | |
| AppealCategoryId | Integer | The appeal category ID. | |
| Campaign | String | The campaign associated with the appeal. | |
| CampaignId | Integer | The campaign ID associated with the appeal. | |
| DefaultFundId | Integer | The default fund ID associated with the appeal. | |
| StartDate | Datetime | The appeal start date. | |
| EndDate | Datetime | The appeal end date. | |
| Inactive | Boolean | Whether the appeal is inactive. | |
| Goal | Double | The monetary goal of the appeal. | |
| Notes | String | The appeal notes. | |
| NumberSolicited | Integer | The number of constituents solicited for the appeal. | |
| DefaultGiftAmount | Double | The default gift amount for the appeal. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| IncludeInactive | Boolean | If set to true, includes inactive appeals in the result. |