ODBC Driver for Blackbaud Raisers Edge NXT

Build 24.0.9062

Ratings

Returns a list of ratings for a constituent.

Table Specific Information

Select

The 本製品 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 本製品.
Note: ConstituentId is required in order to query Ratings.

  • ConstituentId supports the '=' operator.
  • IncludeInactive supports the '=' operator.
  • MostRecentlyUsed supports the '=' operator.
For example:
	
	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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062