ODBC Driver for Blackbaud Raisers Edge NXT

Build 24.0.9062

ConstituentConsents

Returns a list of constituent consent records.

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

  • ConstituentId supports the '=' operator.
  • Category supports the '=,in' operators.
  • Channel supports the '=,in' operators.
  • MostRecentOnly supports the '=' operator.
For example:
	
	SELECT * FROM ConstituentConsents WHERE ConstituentId = '280'
	
	SELECT * FROM ConstituentConsents WHERE ConstituentId = '280' AND Channel IN ('Phone', 'Email')
	
	SELECT * FROM ConstituentConsents WHERE ConstituentId = '280' AND Category IN ('Fundraising', 'Newsletter')
	

Columns

Name Type References Description
Id [KEY] String The immutable system record ID of the consent record.
ConstituentId String

Constituents.Id

The immutable system record ID of the constituent the consent is associated to.
Category String The category that the consent response applies to.
Channel String The channel that the consent response applies to.
ConsentDate Datetime The date the consent response was received.
ConsentStatement String The statement the constituent responded to when providing consent.
ConstituentConsentResponse String How the constituent responded to consent for the specified channel/category.
DateAdded Datetime The date the consent response was added.
PrivacyNotice String The privacy notice provided to the constituent.
Source String The source of the consent response from the constituent.
UserName String The user that added the consent response.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
MostRecentOnly Boolean If set to true, includes inactive constituent consents in the result.

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