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

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

Flag

String

Tasklist Flag.

The allowed values are internal, external.