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.
SELECT * FROM Projects WHERE ProjectId = 1 SELECT * FROM Projects WHERE Location = 'abc' AND Type = 'def' AND Division = 'abc' AND Department = 'abc'
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. |