TaskDependencies
To query all of the dependencies of a task.
Table Specific Information
Select
The component 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 within the component.
- TaskId supports the '=' comparison.
For example, the following queries are processed server-side:
SELECT * FROM TaskDependencies WHERE TaskId = '1208618397035168'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Globally unique ID of the task. | |
| Name | String | Name of the task. | |
| Assignee | String |
Users.Id | User to which this task is assigned. |
| AssigneeStatus | String | Scheduling status of this task for the user it is assigned to.
The allowed values are today, upcoming, later, new, inbox. | |
| CreatedAt | Datetime | The time at which this task was created. | |
| ModifiedAt | Datetime | The time at which this task was last modified. | |
| startOn | Date | Date and time on which this task is due, or null if the task has no due time. | |
| DueAt | Datetime | Date and time on which this task is due, or null if the task has no due time. | |
| DueOn | Date | Date on which this task is due, or null if the task has no due date. This takes a date with YYYY-MM-DD format. | |
| Completed | Boolean | True if the task is currently marked complete, false if not. | |
| CompletedAt | Datetime | The time at which this task was completed, or null if the task is incomplete. | |
| CompletedBy | String |
Users.Id | The user who completed this task. |
| Projects | String | Projects of this task is associated with. | |
| WorkspaceId | String |
Workspaces.Id | Globally unique ID of the Workspace. |
| Notes | String | More detailed, free-form textual information associated with the task. | |
| NumberofSubTasks | Integer | The number of subtasks on this task. | |
| ApprovalStatus | String | Reflects the approval status of this task.
The allowed values are pending, approved, rejected, changes_requested. | |
| ResourceSubType | String | The subtype of this resource. Different subtypes retain many of the same fields and behavior, but may render differently in Asana or represent resources with different semantic meaning.
The allowed values are default_task, milestone, section, approval. | |
| HtmlNotes | String | The notes of the text with formatting as HTML. | |
| Memberships | String | Array of projects this task is associated with and the section it is in. | |
| Dependencies | String | Array of resources referencing tasks that this task depends on. | |
| Dependents | String | Array of resources referencing tasks that depend on this task. | |
| Liked | Boolean | True if the task is liked by the authorized user, false if not. | |
| NumberofLikes | Integer | The number of users who have liked this Task. | |
| LikedBy | String | Array of likes for users who have liked this task. | |
| ResourceType | String | The base type of this resource. | |
| IsRenderedAsSeparator | Boolean | In some contexts tasks can be rendered as a visual separator. | |
| Followers | String | Array of users following this task. | |
| Tags | String | Array of tags associated with this task. | |
| ActualTimeMinutes | Double | This value represents the sum of all the Time Tracking entries in the Actual Time field on a given Task. It is represented as a nullable long value. Note: The time tracking feature is only available on the Asana Advanced or a higher subscription. | |
| Parent | String | The parent of this task, or null if this is not a subtask. | |
| ItemURL | String | A URL that points directly to the object within Asana. | |
| External | String | The external field allows you to store app-specific metadata on tasks, including a gid that can be used to retrieve tasks and a data blob that can store app-specific character strings. Note that you will need to authenticate with OAuth to access or modify this data. | |
| AssigneeResourceType | String | The base type of the Assignee resource. | |
| AssigneeName | String | The Assignee user's name. | |
| AssigneeSection | String | The assignee section is a subdivision of a project that groups tasks together in the assignee's 'My Tasks' list. The assignee_section property will be returned in the response only if the request was sent by the user who is the assignee of the task. | |
| AssigneeSectionResourceType | String | The base type of the AssigneeSection resource. | |
| AssigneeSectionName | String | The name of the The name of the section. | |
| StartAt | Datetime | Date and time on which work begins for the task, or null if the task has no start time. It should not be used together with startOn. | |
| CompletedByResourceType | String | The base type of the CompletedBy resource. | |
| CompletedByName | String | The CompletedBy user's name. | |
| WorkspaceResourceType | String | The base type of the Workspace resource. | |
| WorkspaceName | String | The name of the workspace. | |
| CreatedById | String | Globally unique identifier of the resource. | |
| CreatedByResourceType | String | The type of resource. | |
| TaskId [KEY] | String |
Tasks.Id | The task to operate on. |