ODBC Driver for Blackbaud Financial Edge NXT

Build 20.0.7587

Projects

Retrieve and query projects.

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.

  • ProjectId supports the '=' operator. This column is filtered serverside when it is the only specified filter in the criteria.
  • Location,Type,Division and Department support the '=' operator. A blank search is not supported.
For example, the following queries are processed server side:
SELECT * FROM Projects WHERE ProjectId = 1
SELECT * FROM Projects WHERE Location = 'abc' AND Type = 'def' AND Division = 'abc' AND Department = 'abc'  
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.

Columns

Name Type References Description
ProjectId [KEY] Integer The project database identifier.
UiProjectId String The project user-visible identifier.
Description String The project description.
Location String The project location.
EndDate Datetime The project end date, in ISO 8601 format: 2016-03-14.
StartDate Datetime The project start date, in ISO 8601 format: 2016-03-14.
Type String The project type.
AddedBy String The creator of the project.
PostingDate Datetime The date after which to prevent posting, if applicable.
PreventPostingAfter Boolean If preventing data entry, if to prevent posting after a certain date.
Division String The project division.
PreventDataEntry Boolean If to prevent data entry for this project.
ModifiedBy String The modifier of the project.
Status String The project status.
Department String The project department.
AccountRestrictions String The account allowances or restrictions for this project.
DateAdded Datetime The created date of the project.
DateModified Datetime The modified date of the project.
CustomFields String Custom field : The list of custom fields supported as distict columns.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587