JDBC Driver for Blackbaud Raisers Edge NXT

Build 22.0.8462

Memberships

Returns a list of memberships.

Table Specific Information

Select

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

  • ConstituentId supports the '=' operator.
  • DateAdded supports the '>=,>' operators.
  • DateModified supports the '>=,>' operators.
For example:
	
	SELECT * FROM Memberships WHERE ConstituentId = '280'
	
	SELECT * FROM Memberships WHERE DateAdded >= '2010-06-01 14:03:35'

Columns

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

Constituents.Id

The immutable system record ID of the constituent associated with the membership.
Category String The membership category.
DateAdded Datetime The date when the membership was created.
DateModified Datetime The date when the membership was last modified.
DuesValue Integer The membership dues.
Expires Datetime The date when the membership expires.
Joined Datetime The date when the membership becomes active.
Program String The membership program.
Standing String The membership status. Available values are New, Active, Lapsed, and Dropped.
Subcategory String The membership subcategory.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462