JDBC Driver for Zoho Projects

Build 22.0.8462

BugTimelogs

Gets the time logs under a specific bug.

Select

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

Insert

To add a Bug TimeLog specify the BugId and Follower fields.

INSERT INTO BugTimelogs (BugId, LogDate, BillStatus, HoursDisplay, Notes)
VALUES ('123456000000045005', '2022-03-03', 'Non Billable', '01:20', 'This is a test timelog')

Update

To update a Bug TimeLog specify the BugId and Id fields.

UPDATE BugTimelogs
	SET Notes = 'This is an updated SQL Note'
	WHERE BugId = '165818000000045005' AND Id = '123456000000044025'

Delete

Bug TimeLogs can be deleted by providing the BugId and Id and issuing a DELETE statement.

DELETE FROM BugTimelogs WHERE BugId = '123456000000045005' AND Id = '123456000000044025'

Columns

Name Type ReadOnly Description
BugId [KEY] String False

Bug Id.

Id [KEY] String False

Bug Time Log Id.

AddedByName String False

Bug Time Log Added By Name.

AddedByZpuid String False

Bug Time Log Added By ZPUID.

AddedByZuid Long False

Bug Time Log Added By ZUID.

ApprovalStatus String False

Bug Time Log Approval Status.

ApproverName String False

Bug Time Log Approver Name.

BillStatus String False

Bug Time Log Bill Status.

The allowed values are Billable, Non Billable.

BugTitle String False

Bug Time Log Bug Title.

CreatedDate Date False

Bug Time Log Created Date.

CreatedDateTime Datetime False

Bug Time Log Created Date Time.

Hours Integer False

Bug Time Log Hours.

Minutes Integer False

Bug Time Log Minutes.

HoursDisplay String False

Bug Time Log Hours Display.

LastModifiedDate Date False

Bug Time Log Last Modified Date.

LastModifiedDateTime Datetime False

Bug Time Log Last Modified Date Time.

LinkSelfUrl String False

Bug Time Log Link Self Url.

LogDate Date False

Bug Time Log Date.

LogDateTime Datetime False

Bug Time Log Date Time.

Notes Unknown False

Bug Time Log Notes.

OwnerId String False

Bug Time Log Owner Id.

OwnerName String False

Bug Time Log Owner Name.

TotalMinutes Integer False

Bug Time Log Total Minutes.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462