TDV Adapter for Blackbaud Raisers Edge NXT

Build 22.0.8383

Events

Returns a list of events

Table Specific Information

Select

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

  • Id supports the '=' operator.
  • CategoryName supports the '=' operator.
  • DateAdded supports the '>=,>' operators.
  • DateModified supports the '>=,>' operators.
  • Name supports the '=' operator.
  • StartDate supports the '>=,<=' operators.
  • IncludeInactive supports the '=' operator.
  • Fields supports the '=' operator.
For example:
	
	SELECT * FROM Events WHERE Id = '2'
	
	SELECT * FROM Events WHERE StartDate >= '2000-04-06T05:50:00' AND StartDate <= '2020-04-06T06:50:00'
	
	SELECT * FROM Events WHERE DateAdded >= '2010-06-01 14:03:35'

Columns

Name Type References Description
Id [KEY] String The ID of the event.
AttendedCount Integer The number of event attendees.
AttendingCount Integer The number of event participants who plan to attend.
CampaignId String The ID of the campaign affiliated with the event.
Capacity Integer The number of people that can attend the event.
CategoryId String The ID of the event category.
CategoryInactive Boolean Whether the category is inactive.
CategoryName String The name of the event category.
DateAdded Datetime The date when the event was created.
DateModified Datetime The date when the event was last modified.
EndDate Datetime The end date of the event.
EndTime String The end time of the event.
FundId String The ID of the fund affiliated with the event.
Goal Double The monetary goal of the event.
Inactive Boolean Whether the event is inactive.
InvitedCount Integer The number of event invitees.
LocationName String The name of the location.
LocationAddressLines String The location's address lines.
LocationPostalCode String The location's postal code.
LocationLocalityId String The record ID of the locality record.
LocationLocalityName String The name of the locality.
LocationAdministrativeAreaId String The record ID of the administrative area.
LocationAdministrativeAreaName String The name of the administrative area.
LocationAdministrativeAreaShortDesc String The short description of the administrative area.
LocationSubAdministrativeAreaId String The ID of the sub administrative area.
LocationSubAdministrativeAreaName String The name of the sub administrative area.
LocationCountryId String The ID of the country record.
LocationCountryDisplayName String The display name of the country.
LocationCountryIsoAlpha2Code String The ISO 3166-1 alpha-2 code for the country.
LocationFormattedAddress String The location's formatted address.
LookupId String The lookup ID of the event.
Name String The name of the event.
StartDate Date The start date of the event.
StartTime String The start time of the event.

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
Fields String Represents a list of fields to include on the returned records
IncludeInactive Boolean If set to true, includes inactive phones in the result.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 22.0.8383