TaskStatuses
Get task count of a project.
Table Specific Information
Select
The add-in 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 add-in.
- 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. |