ProjectContacts
The contacts for a project.
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 the only supported filter.
SELECT * FROM ProjectContacts WHERE ProjectId = 1
Columns
| Name | Type | References | Description |
| ProjectId [KEY] | Integer |
Projects.ProjectId | The identifier for this project. |
| ContactId [KEY] | Integer | The identifier for this contact. | |
| Description | String | The description for this address. | |
| Country | String | The country for the address. | |
| City | String | The city for the address. | |
| County | String | The county for this address. | |
| State | String | The state or province (or suburb in NZ) for the address. | |
| Address_line | String | The street information / address line for this address. | |
| Postal | String | Refers to the Postal Code or ZIP of the address. | |
| Title | String | The title for the primary contact. | |
| FirstName | String | The first name of the primary contact. | |
| MiddleName | String | The middle initial or name of the primary contact. | |
| LastName | String | The last name of the primary contact. | |
| Suffix | String | The suffix of the primary contact. | |
| Position | String | The position of the primary contact. |