Excel Add-In for Zoho Projects

Build 23.0.8839

Tasklists

Get all the task lists in the given project.

Select

  • MilestoneId and Flag support the following operator: =.
For example, the following query is processed server side:
SELECT * FROM Tasklists WHERE MilestoneId = '12345600000123' AND Flag = 'internal' 

Insert

To create a new Tasklist you can specify the following fields:

  • Name
  • MilestoneId
  • TaskTemplateId
  • ShiftDays
  • Flag


INSERT INTO Tasklists (name, flag, ShiftDays)
VALUES ('New Tasklist #2', 'internal', '2022-03-10T01:00:00Z')

Update

To update a Tasklist specify the Id field.

UPDATE Tasklists SET Name = 'SQL Updated tasklist #7' WHERE Id = '123456000000041033'

Delete

Tasklists can be deleted by providing the Id and issuing a DELETE statement.

DELETE FROM Tasklists WHERE Id = '123456000000041033'

Columns

Name Type ReadOnly Description
Id [KEY] String False

Tasklist Id.

Name String False

Tasklist Name.

Completed Boolean False

Tasklist Completed.

CreatedDate Date False

Tasklist Created Date.

CreatedDateTime Datetime False

Tasklist Created Date Time.

LastUpdatedDate Date False

Tasklist Last Updated Date.

LastUpdatedDateTime Datetime False

Tasklist Last Updated Date Time.

LinkSelfUrl String False

Tasklist Link Self Url.

LinkTaskUrl String False

Tasklist Link Task Url.

MilestoneClosed Boolean False

Tasklist Milestone Closed.

MilestoneCreatedDate Date False

Tasklist Milestone Created Date.

MilestoneCreatedDateTime Datetime False

Tasklist Milestone Created Date Time.

MilestoneEndDate Date False

Tasklist Milestone End Date.

MilestoneEndDateTime Datetime False

Tasklist Milestone End Date Time.

MilestoneFlag String False

Tasklist Milestone Flag.

MilestoneId String False

Tasklist Milestone Id.

MilestoneIsWorkfieldRemoved Boolean False

Tasklist Milestone Is Workfield Removed.

MilestoneLastUpdatedDate Date False

Tasklist Milestone Last Updated Date.

MilestoneLastUpdatedDateTime Datetime False

Tasklist Milestone Last Updated Date Time.

MilestoneLinkSelfUrl String False

Tasklist Milestone Link Self Url.

MilestoneLinkStatusUrl String False

Tasklist Milestone Link Status Url.

MilestoneName String False

Tasklist Milestone Name.

MilestoneOwnerId String False

Tasklist Milestone Owner Id.

MilestoneOwnerName String False

Tasklist Milestone Owner Name.

MilestoneOwnerZpuid String False

Tasklist Milestone Owner Zpuid.

MilestoneProjectId String False

Tasklist Milestone Project Id.

MilestoneProjectName String False

Tasklist Milestone Project Name.

MilestoneSequence Integer False

Tasklist Milestone Sequence.

MilestoneStartDate Date False

Tasklist Milestone Start Date.

MilestoneStartDateTime Datetime False

Tasklist Milestone Start Date Time.

MilestoneStatus String False

Tasklist Milestone Status.

MilestoneStatusDetColorcode String False

Tasklist Milestone Status Det Colorcode.

MilestoneStatusDetId String False

Tasklist Milestone Status Det Id.

MilestoneStatusDetName String False

Tasklist Milestone Status Det Name.

Rolled Boolean False

Tasklist Rolled.

Sequence Integer False

Tasklist Sequence.

TaskCountOpen Integer False

Tasklist Task Count Open.

TaskTemplateId String False

Id of the task list template.

ShiftDays Datetime False

The ISO 8601 Datetime from which the Task start date is calculated, based on shift days.

Pseudo-Columns

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

Name Type Description
Flag String

Tasklist Flag.

使用できる値は次のとおりです。internal, external

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