OpportunityStatusHistories
Returns a list of histories for an opportunity
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.
Note: OpportunityId is required in order to query OpportunityStatusHistories.
- OpportunityId supports the '=' operator.
select * from OpportunityStatusHistories where OpportunityId IN (select id from opportunities limit 10)
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The primary identifier for the opportunity status history | |
| AuthorID | String | The author id of the status history record. | |
| AuthorName | String | The author name of the status history record. | |
| Comments | String | The comments for the opportunity status history | |
| DaysElapsed | Integer | The number of days elapsed in this particular opportunity status | |
| IsBlackbaudProcessed | Boolean | Whether or not the status history record was created by Blackbaud | |
| IsClosed | Boolean | Is the status closed. | |
| IsPastDue | Boolean | Is the status past due. | |
| OpportunityId | String | The opportunity identifier for the opportunity status history | |
| StartDate | Datetime | The status start date for the opportunity status history | |
| StatusDescription | String | The status description for the opportunity status history | |
| StatusId | String | The status identifier for the opportunity status history |