JDBC Driver for Blackbaud Raisers Edge NXT

Build 22.0.8462

GiftBatches

Returns a list of gift batches.

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.

  • BatchNumber supports the '=' operator.
  • CreatedBy supports the '=' operator.
  • HasExceptions supports the '=' operator.
  • IsApproved supports the '=' operator.
  • SearchText supports the '=' operator.

Columns

Name Type References Description
Id [KEY] String The batch identifier.
ActualAmount Integer The actual batch amount.
BatchDescription String The batch description.
BatchNumber String The batch number.
CreatedBy String Created by user name.
AddedBy String Added by user name.
CreatedOn Datetime The date the batch was created.
DateAdded Datetime The date the batch was added.
HasExceptions Boolean The has exceptions boolean.
IsApproved Boolean Approved boolean.
Approved Boolean Approved boolean.
NumberOfGifts Integer The number of gifts in the batch.

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
SearchText String If set to true, includes inactive gift batches in the result.

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