JDBC Driver for Blackbaud Financial Edge NXT

Build 21.0.7930


Retrieve and query accounts.

The driver will use the Blackbaud Financial Edge NXT API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.

  • Id supports the '=' operator. This column is filtered serverside when it is the only specified filter in the criteria.
  • DateModified supports the following operators : >,>=.
For example, the following queries are processed server side:
SELECT * FROM Accounts WHERE AccountId = 123
SELECT * FROM Accounts WHERE DateModified >= '2010-01-01 10:10:10'
SELECT * FROM Accounts WHERE DateModified > '2010-01-01 10:10:10' 
You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will result in unfiltered data being pushed.


Name Type References Description
AccountId [KEY] Integer The identifier for this account.
AccountNumber String The account number for this account.
Class String The class for this account.
Description String The description for this account.
DateModified Datetime The modified date of the account.
WorkingCapital String The working capital schedule for this account.
Cashflow String The cash flow for this account.
PreventPostingDate Datetime If, and the date after which, to prevent posting. Filling out this field will automatically set the prevent data entry field to 'true'.
ModifiedBy String The modifier of the account.
DefaultTransactionCodes String The default transaction codes on this account.
PreventDataEntry Boolean If to prevent data entry. If a date is given for prevent posting, this value is set to true.
DateAdded Datetime The created date of the account.
AddedBy String The creator of the account.
CustomFields String Custom field : The list of custom fields supported as distict columns.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930