Opportunities
Retrieves a list of opportunities
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.
- 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 | Datetime | 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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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. |