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