ActivityTaskList
Task completion analytics by user for a given date range.
View Specific Information
Select
The add-in 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 add-in.
- Start supports the '=' operator.
- End supports the '=' operator.
- Max supports the '=' operator.
- TypeIds supports the '=' operator.
- PriorityIds supports the '=' operator.
The add-in processes other filters client-side within the add-in. 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. |