ConstituentConsents
Returns a list of constituent consent records.
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 ConstituentConsents.
- ConstituentId supports the '=' operator.
- Category supports the '=,in' operators.
- Channel supports the '=,in' operators.
- MostRecentOnly supports the '=' operator.
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. |