NXTCampaigns
Returns a list of campaigns.
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.
- CampaignId supports the '=' operator.
- Description supports the '=' operator.
- IncludeInactive supports the '=' operator.
SELECT * FROM NXTCampaigns WHERE CampaignId = 'CAMP2018' SELECT * FROM NXTCampaigns WHERE IncludeInactive = true
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | The immutable system record ID of the campaign. | |
| CampaignId | String | The user-defined identifier for the campaign. | |
| Description | String | The campaign description. | |
| CampaignCategory | String | The campaign category name. | |
| CampaignCategoryId | Integer | The campaign category ID. | |
| DefaultFundId | Integer | The default fund ID associated with the campaign. | |
| StartDate | Datetime | The campaign start date. | |
| EndDate | Datetime | The campaign end date. | |
| Inactive | Boolean | Whether the campaign is inactive. | |
| Goal | Double | The monetary goal of the campaign. | |
| Notes | String | The campaign notes. |
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 campaigns in the result. |