CustomFields
To view the Custom Fields in the project.
Table Specific Information
Select
The add-in uses the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side in the add-in.
- ProjectId supports the '=' comparison.
For example, the following query is processed server side:
SELECT * FROM CustomFields WHERE ProjectId = '1126938691750986'
Columns
Name | Type | References | Description |
Id | String | Globally unique identifier of the resource. | |
Name | String | The name of the custom field. | |
Description | String | The description of the custom field. | |
Type | String | The type of the custom field. It must be one of the given values. | |
ProjectId | String | Globally unique Id of the project. | |
ProjectName | String | Name of the project. | |
IsImportant | Boolean | Name of the project. | |
Format | String | The format of the custom field. | |
TextValue | String | The value of a text custom field. | |
NumberValue | Double | The value of a number custom field. | |
Precision | Integer | Only relevant for custom fields of type 'Number'. This field specifies the number of digits after the decimal to round to. | |
CurrencyCode | String | The currency code for this custom field. The value is null if the format is not currency. | |
EnumOptions | String | Array of projects this task is associated with and the section it is in. | |
CreatedBy | String | Globally unique user identifier. | |
CreatedByName | String | The user's name. | |
IsGlobaltoWorkspace | Boolean | A flag that specifies whether this custom field is available to every container in the workspace. | |
HasNotificationsEnabled | Boolean | A flag that specifies whether a follower of a task with this field should receive inbox notifications about changes in this field. |