ProjectTemplates
TO get ProjectTemplates in the Team or workspace.
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.
- TeamId supports the '=' comparison.
- WorkspaceId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM ProjectTemplates where Id = '1208187943633195' SELECT * FROM ProjectTemplates where TeamId = '1207673648001734' SELECT * FROM ProjectTemplates WHERE WorkspaceId = '1208200246477352'
In case of UseTypeaheadSearch property set to true, only Name and WorkspaceId columns would be filterable server side with Name supporting '=, LIKE' comparison when LIKE used only in the following ways:
SELECT * FROM ProjectTemplates WHERE Name = 'abc' SELECT * FROM ProjectTemplates WHERE Name LIKE 'abc' SELECT * FROM ProjectTemplates WHERE Name LIKE 'abc%' SELECT * FROM ProjectTemplates WHERE Name LIKE 'abc%' AND WorkspaceId = '1208200246477352'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Globally unique identifier of the resource, as a string. | |
| Color | String | Color of the project template. | |
| Description | String | Free-form textual information associated with the project template. | |
| Html_description | String | The description of the project template with formatting as HTML. | |
| Name | String | Name of the project template. | |
| OwnerId | String |
Users.Id | A user object. Globally unique identifier of the resource, as a string. |
| OwnerName | String | A user object. The base type of this resource. | |
| OwnerResourceType | String | A user object. Read-only except when same user as requester. The name of the User. | |
| IsPublic | Boolean | True if the project template is public to its team. | |
| RequestedDates | String | Array of date variables in this project template. Calendar dates must be provided for these variables when instantiating a project. | |
| ResourceType | String | The base type of this resource. | |
| TeamId | String |
Teams.Id | A team is used to group related projects and people together within an organization. Globally unique identifier of the resource, as a string. |
| TeamName | String | A team is used to group related projects and people together within an organization. The name of the team. | |
| TeamResourceType | String | A team is used to group related projects and people together within an organization. The base type of this resource. | |
| RequestedRoles | String | Array of template roles in this project template. User Ids can be provided for these variables when instantiating a project to assign template tasks to the user. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| WorkspaceId | String | The workspace Id to filter results on. |