Tableau Connector for Blackbaud Raisers Edge NXT

Build 21.0.7930

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.
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

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.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930