ADO.NET Provider for Asana

Build 20.0.7655

TaskStatuses

Get task count of a project

Table Specific Information

Select

The {i 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 {i.

  • 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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7655