Excel Add-In for Zoho Projects

Build 23.0.8839

TaskTimelogs

Gets the time logs under a specific task.

Select

  • TaskId is required to retrieve Task Time Logs.
For example, the following query is processed server side:
SELECT * FROM TaskTimelogs WHERE TaskId = '123456000000045005'

Insert

To create a new Task Timelog you can specify the following fields:

  • TaskId
  • BillStatus
  • Notes
  • HoursDisplay
  • LogDate
  • OwnerId


INSERT INTO TaskTimelogs (TaskId, LogDate, BillStatus, HoursDisplay, Notes) " +
VALUES ('123456000000040013', '2022-03-03', 'Non Billable', '01:20', 'This is a test timelog')

Update

To update a Task TimeLog specify the TaskId and Id fields.

UPDATE TaskTimelogs
	SET Notes = 'This is an updated SQL Note'
	WHERE TaskId = '165818000000040013' AND Id = '165818000000045001'

Delete

Task TimeLogs can be deleted by providing the TaskId and Id and issuing a DELETE statement.

DELETE FROM TaskTimelogs WHERE TaskId = '123456000000045005' AND Id = '123456000000044025'

Columns

Name Type ReadOnly Description
TaskId [KEY] String False

Task Id.

Id [KEY] String False

Task Time Log Id.

AddedByName String False

Task Time Log Added By Name.

AddedByZpuid String False

Task Time Log Added By Zpuid.

AddedByZuid Long False

Task Time Log Added By Zuid.

ApprovalStatus String False

Task Time Log Approval Status.

ApproverName String False

Task Time Log Approver Name.

BillStatus String False

Task Time Log Bill Status.

使用できる値は次のとおりです。Billable, Non Billable

CreatedDate Date False

Task Time Log Created Date.

CreatedDateTime Datetime False

Task Time Log Created Date Time.

StartTime Datetime False

Task Time Log Start Time.

EndTime Datetime False

Task Time Log End Time.

Notes String False

Task Time Log Notes.

HoursDisplay String False

Task Time Log Hours Display.

Hours Integer False

Task Time Log Hours.

Minutes Integer False

Task Time Log Minutes.

IsParent Boolean False

Task Time Log Is Parent.

IsSubTask Boolean False

Task Time Log Is Sub Task.

LastModifiedDate Date False

Task Time Log Last Modified Date.

LastModifiedDateTime Datetime False

Task Time Log Last Modified Date Time.

LinkSelfUrl String False

Task Time Log Link Self Url.

LogDate Date False

Task Time Log Date.

LogDateTime Datetime False

Task Time Log Date Time.

OwnerId String False

Task Time Log Owner Id.

OwnerName String False

Task Time Log Owner Name.

SubTaskLevel String False

Task Time Log Sub Task Level.

TaskName String False

Task Time Log Task Name.

TaskListId Long False

Task Time Log Task List Id.

TaskListName String False

Task Time Log Task List Name.

TotalMinutes Integer False

Task Time Log Total Minutes.

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