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 connector 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 connector.
- 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 |
Users.Id |
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. |