Excel Add-In for Zoho Projects

Build 23.0.8839

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.

使用できる値は次のとおりです。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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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

使用できる値は次のとおりです。completed, notcompleted

Time String Task Time.

使用できる値は次のとおりです。overdue, today, tomorrow

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839