ODBC Driver for Zoho Projects

Build 26.0.9770

Tasklists

Gets all the task lists in the given project.

Select

  • Id supports '=' operator
  • Name supports '=,!=,CONTAINS' operators
  • Status supports '=' operator
  • Flag supports '=,!=' operators
  • ViewId supports '=' operator

  • Columns that support server-side ORDER BY: Id, Flag, CreatedTime, LastUpdatedTime
For example, the following query is processed server side: 
SELECT * FROM Tasklists WHERE Name = 'TL-02' AND Status = 'completed' AND Flag = 'internal'

Insert

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

  • Name
  • MilestoneId
  • Tags
  • Status
  • Flag


INSERT INTO Tasklists (name, flag, Status)
VALUES ('New Tasklist #2', 'internal', 'active')

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] Long True

Unique identifier of the task list.

Name String False

Name of the task list.

Status String False

Status of the task list.

The allowed values are active, completed.

Flag String False

Flag indicating the type of task list.

The allowed values are internal, external.

CreatedTime Datetime True

Timestamp indicating when the task list was created.

CreatedVia String True

Source through which the task list was created.

LastUpdatedTime Datetime True

Timestamp indicating when the task list was last updated.

ProjectId Long True

Identifier of the project.

ProjectName String True

Name of the project.

MilestoneId Long False

Identifier of the phase associated with the task list.

MilestoneName String True

Name of the phase.

MilestoneSequence Integer True

Order of the task list within the phase.

ProjectSequence Integer True

Order of the task list within the project.

CreatedByZuid Long True

Zoho user ID of the creator.

CreatedByZpuid Long True

Portal-specific user ID of the creator.

CreatedByName String True

Display name of the creator.

CreatedByEmail String True

Email address of the creator.

CreatedByFirstName String True

First name of the creator.

CreatedByLastName String True

Last name of the creator.

Color String False

Color hex code associated with the task list.

Tags String False

Tags associated with the task list.

FilteredTaskCount Integer True

Number of tasks matching the applied filter.

OpenTaskCount Integer True

Number of open tasks.

ClosedTaskCount Integer True

Number of closed tasks.

HasComments Boolean True

Indicates whether the task list contains comments.

IsCompleted Boolean True

Indicates whether the task list is marked as completed.

IsGeneral Boolean True

Indicates whether the task list is a general task list.

IsNoneMilestoneTasklist Boolean True

Indicates whether the task list is not associated with any phase.

IsRolled Boolean True

Indicates whether the task list has been rolled over.

ViewId Long True

Identifier of a custom view to filter task lists.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770