ParticipantOptions
Returns the participant options for a participant.
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: ParticipantId is required in order to query ParticipantOptions.
- ParticipantId supports the '=' operator.
SELECT * FROM ParticipantOptions WHERE ParticipantId = '197'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The ID of the participant option. | |
| ParticipantId | String | The ID of the participant. | |
| AddedByService | String | The name of the service that added this participant option. | |
| AddedByUser | String | The ID of the user that added the participant option. | |
| DateAdded | Datetime | The date the participant option was added. | |
| DateUpdated | Datetime | The date the participant option was updated. | |
| EventId | String | The ID of the event. | |
| EventParticipantOptionId | String | The ID of the event participant option. | |
| OptionValue | String | The participant's response to the option. | |
| UpdatedByService | String | The name of the service that updated this participant option. | |
| UpdatedByUser | String | The ID of the user who updated the participant option. |