TaskSubtasks
View all the subtasks of the given task.
Select
- TaskId is required to retrieve Task Subtasks.
SELECT * FROM TaskSubtasks WHERE TaskId = '12345600000123'
Insert
To create a new Task you can specify the following fields:
- TaskId
- Name
- Description
- Duration
- DurationType
- Priority
- StartDate
- EndDate
- PersonResponsible
INSERT INTO TaskSubtasks (TaskId, Name, StartDate, EndDate, Duration, DurationType, Priority, Description)
VALUES ('165818000000040013', 'Sql Subtask #4', '2022-03-01', '2022-03-10', '2', 'hrs', 'High', 'Test description of the subtask')
Columns
| Name | Type | ReadOnly | Description |
| TaskId | String | False |
Task Id. |
| Id [KEY] | String | False |
Subtask Id. |
| Name | String | False |
Subtask Name. |
| Key | String | False |
Subtask Key. |
| BillingType | String | False |
Subtask Billing Type. |
| Completed | Boolean | False |
Subtask Completed. |
| CreatedBy | String | False |
Subtask Created By. |
| CreatedByEmail | String | False |
Subtask Created By Email. |
| CreatedByZpuid | String | False |
Subtask Created By Zpuid. |
| CreatedPerson | String | False |
Subtask Created Person. |
| CreatedTime | Date | False |
Subtask Created Time. |
| CreatedDateTime | Datetime | False |
Subtask Created Date Time. |
| Depth | Integer | False |
Subtask Depth. |
| Description | String | False |
Subtask Description. |
| DetailsOwners | String | False |
Subtask Details Owners. |
| Duration | String | False |
Subtask Duration. |
| DurationType | String | False |
Subtask Duration Type. 使用できる値は次のとおりです。days, hrs |
| IsCommentAdded | Boolean | False |
Subtask Is Comment Added. |
| IsDocsAssociated | Boolean | False |
Subtask Is Docs Associated. |
| IsForumAssociated | Boolean | False |
Subtask Is Forum Associated. |
| IsRecurrenceSet | Boolean | False |
Subtask Is Recurrence Set. |
| IsReminderSet | Boolean | False |
Subtask Is Reminder Set. |
| IsParent | Boolean | False |
Subtask Is Parent. |
| LastUpdatedTime | Date | False |
Subtask Last Updated Time. |
| LastUpdatedDateTime | Datetime | False |
Subtask Last Updated Date Time. |
| LinkSelfUrl | String | False |
Subtask Link Self Url. |
| LinkTimesheetUrl | String | False |
Subtask Link Timesheet Url. |
| LinkWebUrl | String | False |
Subtask Link Web Url. |
| LogBillableHours | String | False |
Subtask Log Billable Hours. |
| LogNonBillableHours | String | False |
Subtask Log Non Billable Hours. |
| MilestoneId | String | False |
Subtask Milestone Id. |
| OrderSequence | Integer | False |
Subtask Order Sequence. |
| ParentTaskId | String | False |
Subtask Parent Task Id. |
| PercentComplete | String | False |
Subtask Percent Complete. |
| Priority | String | False |
Subtask Priority. 使用できる値は次のとおりです。none, low, medium, high |
| RootTaskId | String | False |
Subtask Root Task Id. |
| StatusColorCode | String | False |
Subtask Status Color Code. |
| StatusId | String | False |
Subtask Status Id. |
| StatusName | String | False |
Subtask Status Name. |
| StatusType | String | False |
Subtask Status Type. |
| Subtasks | Boolean | False |
Subtask Subtasks. |
| TaskFollowers | String | False |
Subtask Task Followers. |
| TaskFollowerSize | Integer | False |
Subtask Task Follower Size. |
| TasklistId | String | False |
Subtask Tasklist Id. |
| TasklistName | String | False |
Subtask Tasklist Name. |
| Work | String | False |
Subtask Work. |
| WorkForm | String | False |
Subtask Work Form. |
| WorkType | String | False |
Subtask Work Type. |
| GroupNameAssociatedTeamsAnyTeam | String | False |
Subtask Group Name Associated Teams Any Team. |
| GroupNameAssociatedTeamsCount | Integer | False |
Subtask Group Name Associated Teams Count. |
| GroupNameIsTeamUnassigned | Boolean | False |
Subtask Group Name Is Team Unassigned. |
| StartDate | Date | False |
Subtask Start Date. |
| EndDate | Date | False |
Subtask End Date. |
| PersonResponsible | String | False |
Subtask Person Responsible. |