JDBC Driver for Zoho Projects

Build 22.0.8389

TaskSubtasks

View all the subtasks of the given task.

Select

  • TaskId is required to retrieve Task Subtasks.
You can use the below query to get all 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.

The allowed values are 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.

The allowed values are 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.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 22.0.8389