TaskDependents
To query all of the dependents of a task.
Table Specific Information
Select
The 本製品 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 本製品.
- TaskId supports the '=' comparison.
For example, the following queries are processed server-side:
SELECT * FROM TaskDependents 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.
使用できる値は次のとおりです。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.
使用できる値は次のとおりです。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.
使用できる値は次のとおりです。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. |