ProjectTemplates
TO get ProjectTemplates in the Team or workspace.
Table Specific Information
Select
The component 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 component.
- 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. |