data model capture projects tasks and subtasks

It is used to distinguish folders with the same name Name of folder/project/space that limits information displayed in the analytics board, along with its ID. Name of folder/project/space that limits information displayed in the analytics board Typically such filter is applied based on the Space/folder selected when creating an analytics board Top-level filter used to present information from only certain spaces/folders. The timelog entry was created for this date 1 means that task is directly attached to a folder or project subtask or task of the child folder/project can have depth level of 2 and more User Name, only filled in if the custom field type is PeopleĪttributes of tasks relative to its folders/projectsĭepth level of task within the project. Only filled in if the custom field type is Numeric* (Number), Money* (Currency) or Percent* (Percent), Duration or type is Enumeration* (Single select), Multiselect* (Multiple select) and values are numeric Only filled in if the custom field type is Date Value of the custom field in string format, always filled inĭate value of the custom field. Can be one of Text, Enumeration* (Single select), Numeric* (Number), Boolean* (Checkbox), Money* (Currency), Percent* (Percent), Date, Duration, People, Checkbox, Contacts, Multiselect* (Multiple select) Shows if weekends and holidays are ignored when calculating task duration Task billing type (Billable/Non-billable) Possible options: None, FullTime, Basic, Flexible Workflow of the status assigned to a task Can be one of Active, Completed, Deferred, Cancelled groups Use this field in Pie, Bar, Pivot and other charts to make the color match the workspace color of the status Status of the task combined with its color representation. Empty if the task is in any status from the Active Status Group

Tasks from projects or folders not shared with the user will not be shownĭate when task status was changed into any status from the Completed, Deferred or Cancelled Status Groups. Name of the user, only filled in if the custom field type is PeopleĪll tasks shared with current user. Only filled in if type is Boolean* (Checkbox) Only filled in if the custom field type is Numeric* (Number), Money* (Currency) or Percent* (Percent), Duration or type is Enumeration* (Single select), Multiselect* (Multiple select) and values are numericįolder/Project Custom Field Checkbox ValueĬheckbox value - true or false. Only filled in if the custom field type is Text, Enumeration* (Single select) or Multiselect* (Multiple select)įolder/Project Custom Field Numeric Value Value of the field in string format, always filled inĭate value of the custom field. Can be one of Text, Enumeration* (Single select), Numeric* (Number), Date, Boolean* (Checkbox), Money* (Currency), Percent* (Percent), Duration, People, Multiselect* (Multiple select) It's used to distinguish between custom fields with the same name ID of the folder/space, as seen in workspaceįolders/projects/Spaces custom field values* Can be one of Active, Completed, Deferred or Cancelled groups.Īll folders and Spaces shared with current user Status Group of the selected project status.

Status of the project combined with its color representation. Empty if the project is in any status from the Active, Deferred or Cancelled Status Groups Date when project status was changed into Completed Status Group.

Data model capture projects tasks and subtasks