invantive documentation
Invantive Support ForumsLog In / Sign Up

TaskCustomFieldValues: Teamleader Focus Task Custom Field Values

read only

  • Catalog: Teamleader
  • Schema: V2Flat
  • Label: Task Custom Field Values

Can only retrieve data.

Performance Characteristics

Characteristic Value
Average access latency (ms) 39

The result can be cached on the client.

Table Columns

The columns of the table TaskCustomFieldValues are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
cfd_group varchar2 Group filters on the platform, writable, cfd_group Group for grouping multiple custom fields in the web frontend.
cfd_label varchar2 Label filters on the platform, writable, cfd_label Label for display with the value in the web frontend.
cfd_required char Required filters on the platform, writable, cfd_required Whether a value must be provided.
cfd_type varchar2 Type filters on the platform, writable, cfd_type Type of the values stored, such as 'auto_increment', 'integer', 'contact', 'number' or 'multi_line'.
tak_added_at datetime Added At filters on the platform, writable
tak_assignee_id varchar2 Assignee ID filters on the platform, writable
tak_assignee_type varchar2 Assignee Type filters on the platform, writable
tak_c_autoincrement int32 itgen_teamleader_c_autoincrement filters on the platform, writable
tak_c_company guid itgen_teamleader_c_company filters on the platform, writable
tak_c_date datetime itgen_teamleader_c_date filters on the platform, writable
tak_c_emailaddress varchar2 itgen_teamleader_c_emailaddress filters on the platform, writable
tak_c_integer int32 itgen_teamleader_c_integer filters on the platform, writable
tak_c_maximale_waarde decimal itgen_teamleader_c_maximale_waarde filters on the platform, writable
tak_c_number decimal itgen_teamleader_c_number filters on the platform, writable
tak_c_phonenumber varchar2 itgen_teamleader_c_phonenumber filters on the platform, writable
tak_c_singlelinetext varchar2 itgen_teamleader_c_singlelinetext filters on the platform, writable
tak_c_singleselection varchar2 itgen_teamleader_c_singleselection filters on the platform, writable
tak_c_url varchar2 itgen_teamleader_c_url filters on the platform, writable
tak_c_yesno char itgen_teamleader_c_yesno filters on the platform, writable
tak_completed char Completed filters on the platform, writable
tak_completed_at datetime Completed at filters on the platform, writable
tak_customer_id varchar2 Customer ID filters on the platform, writable
tak_customer_type varchar2 Customer Type filters on the platform, writable
tak_deal_id varchar2 Deal ID filters on the platform, writable
tak_deal_type varchar2 Deal Type filters on the platform, writable
tak_description varchar2 Description filters on the platform, writable
tak_due_on datetime Due on filters on the platform, writable
tak_estimated_duration_unit varchar2 Estimated Duration Unit filters on the platform, writable
tak_estimated_duration_value decimal Estimated Duration Value filters on the platform, writable
tak_id varchar2 ID filters on the platform, writable
tak_milestone_id varchar2 Milestone ID filters on the platform, writable
tak_milestone_type varchar2 Milestone Type filters on the platform, writable
tak_priority varchar2 Priority filters on the platform, writable
tak_project_id varchar2 Project ID filters on the platform, writable
tak_project_type varchar2 Project Type filters on the platform, writable
tak_ticket_id varchar2 Ticket ID filters on the platform, writable
tak_title varchar2 Title filters on the platform, writable
tak_work_type_id varchar2 Work Type ID filters on the platform, writable
tak_work_type_type varchar2 Work Type Type filters on the platform, writable
tfe_definition_id varchar2 Definition ID filters on the platform, writable
tfe_definition_type varchar2 Definition Type filters on the platform, writable Type of the custom field definition.
tfe_task_id varchar2 Record ID filters on the platform, writable ID of the task for which these custom field values provide additional information.
tfe_value_as_array varchar2 Array Value filters on the platform, writable
tfe_value_as_boolean char Boolean Value filters on the platform, writable
tfe_value_as_number decimal Numeric Value filters on the platform, writable
tfe_value_as_string varchar2 Text Value filters on the platform, writable
tfe_value_object_id varchar2 ID of Undefined Type filters on the platform, writable
tfe_value_object_type varchar2 Value of Undefined Type filters on the platform, writable

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: