Campaigns
Campaigns are your organization's overall fundraising efforts or initiatives, such as operating expenses, new buildings, and endowments
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.
- DateAdded supports the '>=,>' operators.
- DateModified supports the '>=,>' operators.
- IncludeInactive supports the '=' operators.
SELECT * FROM Campaigns WHERE DateModified >= '2010-06-01 14:03:35' SELECT * FROM Campaigns WHERE IncludeInactive = true
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The immutable system record ID of the campaign. | |
| Category | String | The category of the campaign. | |
| DateAdded | Datetime | The date when the campaign was created. | |
| DateModified | Datetime | The date when the campaign was last modified. | |
| Description | String | The display name of the campaign. | |
| EndDate | Datetime | The end date of the campaign. | |
| GoalValue | Double | The monetary goal associated with the campaign. | |
| Inactive | Boolean | This computed field indicates that the campaign is active if the current date is after any start_date and before any end_date. | |
| LookupId | String | The user-defined identifier for the campaign. | |
| StartDate | Datetime | The start date of the campaign. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| IncludeInactive | Boolean | If set to true, includes inactive campaigns in the result. |