Actions
Retrieves a list of actions for all constituents and for specified constituent and details of the specified action.
Table Specific Information
Select
The 本製品 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 本製品.
- Id supports the '=' operator.
- ComputedStatus supports the '=' operator.
- ConstituentId supports the '=' operator.
- DateAdded supports the '>=,>' operators.
- DateModified supports the '>=,>' operators.
- StatusCode supports the '=,in' operators.
SELECT * FROM Actions WHERE ConstituentId = '280' SELECT * FROM Actions WHERE ComputedStatus = 'Completed' SELECT * FROM Actions WHERE DateAdded >= '2010-06-01 14:03:35'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The immutable system record ID of the action. | |
| Category | String | The channel or intent of the constituent interaction. | |
| Completed | Boolean | Indicates whether the action is complete. | |
| CompletedDate | Datetime | The date when the action was completed. | |
| ComputedStatus | String | The computed action status.
使用できる値は次のとおりです。Open, Completed, PastDue | |
| ConstituentId | String |
Constituents.Id | The immutable system record ID of the constituent associated with the action. |
| Date | Datetime | The action date. | |
| DateAdded | Datetime | The date when the action was created. | |
| DateModified | Datetime | The date when the action was last modified. | |
| Description | String | The detailed explanation that elaborates on the action summary. | |
| Direction | String | The direction of the action. | |
| EndTime | String | The end time of the action. | |
| Fundraisers | String | The set of immutable constituent system record IDs for the fundraisers associated with the action. | |
| Location | String | The location of the action. | |
| OpportunityId | String | The immutable system record ID of the opportunity associated with the action. | |
| Outcome | String | The outcome of the action. Available values are Successful and Unsuccessful. | |
| Priority | String | The priority of the action. | |
| StartTime | String | The start time of the action. | |
| Status | String | The action status. | |
| StatusCode | String | The action status code. This property is only returned when the system is configured to use custom action statuses.
使用できる値は次のとおりです。Closed, Completed, Pending, Not Completed, Open, Sent, Continuous | |
| Summary | String | The short description of the action that appears at the top of the record. | |
| Type | String | Additional description of the action to complement the category. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| ListId | String | Defines a list identifier used to filter the set of actions to those included in the specified list. If this value is set, other specified filters will be ignored. |