ActivityTaskList
Task completion analytics by user for a given date range.
View Specific Information
Select
The driver will use the Act! CRM API to process WHERE clause conditions built with the following column and operator. Start and End are required to make a request and the rest of the filter is executed client-side within the driver.
- Start supports the '=' operator.
- End supports the '=' operator.
- Max supports the '=' operator.
- TypeIds supports the '=' operator.
- PriorityIds supports the '=' operator.
The driver processes other filters client-side within the driver. For example, the following queries are processed server side:
SELECT * FROM ActivityTaskList WHERE Start = '2023-01-01 01:00:00' AND End = '2023-12-31 01:30:00'
Columns
| Name | Type | Description |
| Id [KEY] | String | The unique identifier of the activity task. |
| AccessorActivityId | String | The accessor activity identifier. |
| ContactCount | Integer | The number of contacts associated with the task. |
| StartTime | Datetime | The start time of the task. |
| Regarding | String | A description of what the task is about. |
| Type | String | The type of the activity task. |
| TypeId | Integer | The type identifier of the activity task. |
| Priority | String | The priority of the activity task. |
| ScheduledWith | String | The user the task is scheduled with. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| Start | Datetime | The start date-time for the analytics date-time range. Required. |
| End | Datetime | The end date-time for the analytics date-time range. Required. |
| Max | Integer | The maximum number of records to return. |
| TypeIds | String | Comma-separated list of activity type IDs to filter by. |
| PriorityIds | String | Comma-separated list of priority IDs to filter by. |