JDBC Driver for Asana

Build 24.0.9060

TaskStatuses

Get task count of a project.

Table Specific Information

Select

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

  • 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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060