Lists
Returns a list of lists for the given list type
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.
- ListType supports the '=' operator.
SELECT * FROM Lists WHERE ListType = 'Constituent'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The immutable system record ID for the list. | |
| DateModified | Datetime | The date this list was last modified. | |
| Description | String | The description of the list | |
| IsPublic | Boolean | Indicates whether this is a public or private list. | |
| LastModifiedByUserId | String | The ID of the user that last modified the list. | |
| LastModifiedByUserName | String | The name of the user that last modified the list. | |
| Name | String | The name of the list. | |
| RecordCount | Integer | The total number of records defined by this list based on the last time this list was saved. | |
| ListType | String | Type of the list.
The allowed values are Constituent, Gift, Action, Opportunity. |