TaskCustomfields
Gets all the custom fields for tasks.
Select
Columns that support the = operator:- IsDefault
- IsMandatory
- IsRenamed
- IsUnassociated
- IsAssociationInfoNeeded
- IsFormulaBasedList
- LayoutId
- ProjectId
- FieldIds
- Fields
- SearchTerm
For example, the following query is processed server side:
SELECT * FROM TaskCustomFields WHERE ProjectId = '12345600000123'
Columns
| Name | Type | Description |
| Id [KEY] | Long | Unique custom field identifier.. |
| FieldName | String | Name of the custom field. |
| DisplayName | String | Custom Field Display Name. |
| FieldType | String | Custom Field Type. |
| FieldPropertyIsEncrypted | Boolean | Specifies if the custom field is encrypted. |
| FieldPropertyIsPii | Boolean | Specifies if the custom field contains Personally Identifiable Information. |
| FieldPropertyScope | String | Additional properties specific to the field type. |
| IsDefault | Boolean | Indicates if the field is a default field. |
| IsDeactivated | Boolean | Indicates if the custom Field is Deactivated. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| IsMandatory | Boolean | Specify whether the field must be filled before saving a record. |
| IsRenamed | Boolean | Specify whether to retrieve fields whose display name has been modified. |
| IsUnassociated | Boolean | Specify whether to retrieve fields not associated with any layout. |
| IsAssociationInfoNeeded | Boolean | Specify whether to include layout association details for each field. |
| IsFormulaBasedList | Boolean | Specify whether to retrieve fields eligible for use in formula fields. |
| LayoutId | Long | Layout Id. |
| ProjectId | Long | Project Id. |
| FieldIds | String | Array of field IDs. |
| Fields | String | Array of field API names. |
| SearchTerm | String | Keyword to search fields by name. |