TaskActivities
Retrieve details of who modified a specific task and when.
Select
- TaskId is required to retrieve Task Activities.
SELECT * FROM TaskActivities WHERE TaskId = '123456789'
Columns
| Name | Type | Description |
| Id [KEY] | Long | Task Activity Id. |
| TaskId | Long | Task Id. |
| Name | String | Task Activity Name. |
| OldValue | String | Task Activity Old Value. |
| NewValue | String | Task Activity New Value. |
| State | String | Task Activity State. |
| ActionTime | Datetime | Task Activity Action Time. |
| ActionByZpuid | Long | Task Activity Action By Zpuid. |
| ActionByZuid | Long | Task Activity Action By Zuid. |
| ActionByFirstName | String | Task Activity Action By First Name. |
| ActionByLastName | String | Task Activity Action By Last Name. |
| ActionByName | String | Task Activity Action By Display Name. |
| ActionByEmail | String | Task Activity Action By Email. |