ADO.NET Provider for Asana

Build 20.0.7655

TaskStatuses

Get task count of a project

Table Specific Information

Select

The provider 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 provider.

  • 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