TaskStatuses
Get task count of a project.
Table Specific Information
Select
The connector will use the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.
- ProjectId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM TaskStatuses WHERE ProjectId = '1136437449978157'
Columns
| Name | Type | References | Description |
| ProjectId | String |
Projects.Id | Globally unique ID of the project. |
| NumberofTasks | Integer | The number of tasks in a project. | |
| CompletedTasks | Integer | The number of completed tasks in a project. | |
| IncompleteTasks | Integer | The number of incomplete tasks in a project. | |
| NumberofMilestones | Integer | The number of milestones in a project. | |
| CompletedMilestones | Integer | The number of completed milestones in a project. | |
| InCompleteMilestones | Integer | The number of incomplete milestones in a project. |