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 add-in 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 add-in.
- 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. |