JDBC Driver for Asana

Build 23.0.8839

ProjectStatuses

To Create, Delete and Query from ProjectStatuses table. A project status is an update on the progress of a particular project, and is sent out to all project followers when created.

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.

  • Id supports the '=' comparison.
  • ProjectId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM ProjectStatuses WHERE Id = '1127092449876445'

SELECT * FROM ProjectStatuses WHERE ProjectId = '1127092449876444'

Insert

ProjectId is a mandatory column for inserting into ProjectStatuses table. For example:

INSERT INTO projectstatuses (Color, Title, Text, ProjectId) VALUES ('red', 'Status1', 'StatusNotes', '1127092449876444')

Delete

Following is an example of how to delete from ProjectStatuses table:

DELETE FROM ProjectStatuses WHERE Id = '1127092449876445'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Globally unique ID of the project status update.

Color String True

The color associated with the status update.

The allowed values are green, yellow, red.

Title String True

The title of the project status update.

Text String True

The text content of the status update.

CreatedAt Datetime True

The time at which the status update was created.

CreatedBy String True

The creator of the status update.

ProjectId String True

Projects.Id

Globally unique ID of the project.

ResourceType String True

The resource type of this resource. The value for this resource is always project_status.

HTMLText String True

The notes of the project with formatting as HTML.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839