EventParticipantOptions
Returns the participant options for an event.
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: EventId is required in order to query EventParticipantOptions.
- EventId supports the '=' operator.
SELECT * FROM EventParticipantOptions WHERE EventId = '2'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The ID of the event participant option. | |
| EventId | String |
Events.Id | The ID of the event which the participant belongs to. |
| AddedByService | String | The ID of the service who added this option. | |
| AddedByUser | String | The ID of the user that added this option. | |
| DateAdded | Datetime | The date this option was added. | |
| DateUpdated | Datetime | The date this option was updated. | |
| InputType | String | The available types of event participant options. | |
| ListOptions | String | A event participant option list option. | |
| MultiSelect | Boolean | Only valid for List input type, determines if multiple options can be selected. | |
| Name | String | The name of the event participant option. | |
| ParticipantId | String | The ID of the participant. | |
| UpdatedByService | String | The ID of the service who updated this option. | |
| UpdatedByUser | String | The ID of the user who updated this option. | |
| Version | Integer | The version number of the option. |