Opportunities
Retrieves a list of opportunities
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.
- ConstituentId supports the '=,in' operators.
- DateAdded supports the '>=,>' operators.
- DateModified supports the '>=,>' operators.
- IncludeInactive supports the '=' operator.
SELECT * FROM Opportunities WHERE Id = '4'
SELECT * FROM Opportunities WHERE ConstituentId IN ('255', '266')
SELECT * FROM Opportunities WHERE DateAdded >= '1999-06-01 14:03:35'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The immutable system record ID of the opportunity. | |
| AskAmountValue | Double | The monetary amount solicited from the prospect for the opportunity. | |
| AskDate | Date | The date when the solicitation was made. | |
| CampaignId | String |
Campaigns.Id | The immutable system record ID of the campaign associated with the opportunity. The campaign sets the overall objectives for raising money. |
| ConstituentId | String |
Constituents.Id | The immutable system record ID of the constituent associated with the opportunity. |
| DateAdded | Datetime | The date when the opportunity was created. | |
| DateModified | Datetime | The date when the opportunity was last modified. | |
| Deadline | Datetime | The goal date for the opportunity to result in a gift. | |
| ExpectedAmountValue | Double | The monetary amount that is realistically expected to result from the opportunity. | |
| ExpectedDate | Datetime | The date when the prospect is expected to give in response to the opportunity. | |
| FundId | String |
Funds.Id | The immutable system record ID of the fund associated with the opportunity. |
| FundedAmountValue | Double | The monetary amount that the prospect gave in response to the opportunity. | |
| FundedDate | Datetime | The date when the prospect gave in response to the opportunity. | |
| Fundraisers | String | Fundraiser constituents interact with other constituents and prospects on behalf of your organization to cultivate relationships and advance opportunities to secure major gifts. | |
| Inactive | Boolean | Indicates whether the opportunity is inactive. | |
| LinkedGifts | String | The immutable system record IDs of the gifts related to the opportunity. | |
| Name | String | The name that identifies the opportunity throughout the program, such as in lists or on constituent records. | |
| Purpose | String | The intended use for any money raised as a result of the opportunity. | |
| Status | String | The status that indicates where the opportunity is in the solicitation process. |
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 opportunities in the response. | |
| ListId | String | Defines a list identifier used to filter the set of opportunities to those included in the specified list. If this value is set, other specified filters will be ignored. |