Ratings
Returns a list of ratings for a constituent.
Table Specific Information
Select
The adapter 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 adapter.
Note: ConstituentId is required in order to query Ratings.
- ConstituentId supports the '=' operator.
- IncludeInactive supports the '=' operator.
- MostRecentlyUsed supports the '=' operator.
SELECT * FROM Ratings WHERE ConstituentId = '280' SELECT * FROM Ratings WHERE IncludeInactive = true SELECT * FROM Ratings WHERE MostRecentlyUsed = true
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The immutable system record ID of the rating. | |
| Category | String | The category of the rating. | |
| Comment | String | A comment about the rating. | |
| ConstituentId | String |
Constituents.Id | The immutable system record ID of the constituent associated with the rating. |
| Date | Datetime | The date of the rating. | |
| Inactive | Boolean | This computed field indicates that the rating is active if the category is active. | |
| Source | String | The source of the rating. | |
| Type | String | This computed field indicates the type of data that the rating represents based on the category property. | |
| Value | String | The value of the rating. |
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 ratings in the result. | |
| MostRecentOnly | Boolean | If set to true, includes only most recent ratings in the result. |