IssueTimelogs

Gets the time logs for module type issue in the given project.

Select

Date column supports '>,>=,=,<,<=' operators

For example, the following query is processed server side:

SELECT * FROM IssueTimelogs WHERE Date > '2026-01-01' AND Date < '2026-08-15'

Querying IssueTimelogs without date filter will return data for only the current month:

SELECT * FROM IssueTimelogs

Insert

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

ModuleId
LogDate
Notes
LogHour
BillingStatus
StartTime
EndTime
OwnerZpuid
ApprovalStatus
ApproverZpuid
CostRatePerHourAmount
ForTimer

INSERT INTO IssueTimelogs (LogHour, LogDate, ModuleId, BillingStatus, Notes) VALUES ('02:00', '2022-03-03', '123456000000040013', 'Non Billable', 'This is a test timelog')

Update

To update a Issue TimeLog specify the Id field.

UPDATE IssueTimelogs SET Notes = 'This is an updated SQL Note' WHERE Id = '165818000000045001'

Delete

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

DELETE FROM IssueTimelogs WHERE Id = '123456000000044025'

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Long	True	Unique identifier of the time log.
ModuleId	Long	False	Id of the module associated with the time log entry.
ModuleName	String	True	Name of the module associated with the time log entry.
ModulePrefix	String	True	Prefix of the module associated with the time log entry.
ModuleType	String	True	Type of the module associated with the time log entry.
LogDate	Date	False	Date of the time log in ISO format (YYYY-MM-DD).
Notes	String	False	Additional notes on the time log.
LogNotes	String	True	Log notes associated with the time log.
LogHour	String	False	Logged hours in HH:MM format.
BillingStatus	String	False	Billing status of the time log.
StartTime	String	False	Start time of the work.
EndTime	String	False	End time of the work.
CreatedTime	Datetime	True	Created time of the time log in ISO format.
LastModifiedTime	Datetime	True	Last modified time of the time log in ISO format.
OwnerZpuid	Long	False	Zoho Projects User ID (ZPUID) of the time log owner.
OwnerZuid	Long	True	Zoho User ID (ZUID) of the time log owner.
OwnerFirstName	String	True	First name of the time log owner.
OwnerLastName	String	True	Last name of the time log owner.
OwnerName	String	True	Display name of the time log owner.
OwnerEmail	String	True	Email address of the time log owner.
OwnerImageUrl	String	True	Profile image URL of the time log owner.
AddedByZpuid	Long	True	Zoho Projects User ID (ZPUID) of the time log creator.
AddedByZuid	Long	True	Zoho User ID (ZUID) of the time log creator.
AddedByFirstName	String	True	First name of the time log creator.
AddedByLastName	String	True	Last name of the time log creator.
AddedByName	String	True	Display name of the time log creator.
AddedByEmail	String	True	Email address of the time log creator.
ProjectId	Long	True	Unique identifier of the project.
ProjectName	String	True	Name of the project.
ApprovalStatus	String	False	Approval status of the time log. The allowed values are Approved, Unapproved, Rejected.
ApproverZpuid	Long	False	Zoho Projects User ID (ZPUID) of the approver.
ApproverZuid	Long	True	Zoho User ID (ZUID) of the approver.
ApproverName	String	True	Display name of the approver.
ApproverEmail	String	True	Email address of the approver.
ApprovalTime	String	True	Time of approval.
CostAmount	Decimal	True	Cost amount of the time log.
CostFormattedAmount	String	True	Formatted cost amount of the time log.
CostCurrencyCode	String	True	Currency code for the time log cost.
CostCurrencyId	String	True	Currency id for the time log cost.
CostRatePerHourAmount	Decimal	False	Cost rate per hour amount.
CostRatePerHourFormattedAmount	String	True	Formatted cost rate per hour.
CostRatePerHourCurrencyCode	String	True	Currency code for the cost rate per hour.
CostRatePerHourCurrencyId	String	True	Currency id for the time log cost.
Module	String	True	The type of the module.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.


Name	Type	Description
Date	Date	Time Log Date filter.
ForTimer	Boolean	Specify whether the time log is added from a timer.