JDBC Driver for Zoho Projects

Build 22.0.8462

MyTasks

Gets all your tasks in the portal.

Select

This is a portal-level view. Columns that support the = operator:
  • Id
  • CreatedBy
  • MilestoneId
  • Priority
  • TasklistId
  • Owner
  • Status
  • Time
  • LastModifiedTime
  • ViewId

For example, the following query is processed server side:
SELECT * FROM MyTasks WHERE MilestoneId = '12345600000123' AND Priority = 'High' 

Columns

Name Type Description
ProjectId String Project Id.
Id [KEY] String Task Id.
Name String Task Name.
Key String Task Key.
BillingType String Task Billing Type.
Completed Boolean Task Completed.
CreatedBy String Task Created By.
CreatedByEmail String Task Created By Email.
CreatedByZpuid String Task Created By Zpuid.
CreatedPerson String Task Created Person.
CreatedDate Date Task Created Date.
CreatedDateTime Datetime Task Created Date Time.
Description String Task Description.
Owners String Task Owners.
Duration String Task Duration.
DurationType String Task Duration Type.
EndDate Date Task End Date.
EndDateTime Datetime Task End Date Time.
CommentAdded Boolean Task Comment Added.
DocsAssociated Boolean Task Docs Associated.
ForumAssociated Boolean Task Forum Associated.
RecurrenceSet Boolean Task Recurrence Set.
ReminderSet Boolean Task Reminder Set.
Parent Boolean Task Parent.
LastUpdatedDate Date Task Last Updated Date.
LastUpdatedDateTime Datetime Task Last Updated Date Time.
LinkSelfUrl String Task Link Self Url.
LinkTimesheetUrl String Task Link Timesheet Url.
LinkWebUrl String Task Link Web Url.
LogHoursBillableHours String Task Log Hours Billable Hours.
LogHoursNonBillableHours String Task Log Hours Non Billable Hours.
MilestoneId String Task Milestone Id.
OrderSequence Integer Task Order Sequence.
PercentComplete String Task Percent Complete.
Priority String Task Priority.

The allowed values are none, low, medium, high.

StartDate Date Task Start Date.
StartDateTime Datetime Task Start Date Time.
StatusColorCode String Task Status Color Code.
StatusId String Task Status Id.
StatusName String Task Status Name.
StatusType String Task Status Type.
Subtasks Boolean Task Subtasks.
TaskFollowers String Task Task Followers.
TaskFollowerSize Integer Task Task Follower Size.
TasklistId String Task Tasklist Id.
TasklistIdString String Task Tasklist Id String.
TasklistName String Task Tasklist Name.
Work String Task Work.
WorkForm String Task Work Form.
WorkType String Task Work Type.
GroupNameAssociatedTeamsAnyTeam String Task Group Name Associated Teams Any Team.
GroupNameAssociatedTeamsCount Integer Task Group Name Associated Teams Count.
GroupNameIsTeamUnassigned Boolean Task Group Name Is Team Unassigned.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Owner String Task Owner.
Status String Task Status.

The allowed values are completed, notcompleted.

Time String Task Time.

The allowed values are overdue, today, tomorrow.

LastModifiedTime Datetime Task Last Modified Time.
CustomViewId String Task Custom View Id.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462