Timelogs

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

Select

This is a project-level view, and gives the timelogs for moduletype: general.

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

For example, the following queries are processed server side:

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

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

SELECT * FROM Timelogs

Insert

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

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

INSERT INTO Timelogs (LogHour,LogDate,Name) VALUES ('2','2026-08-10','This is timelog 001.')

Update

To update Timelog specify the Id field.

UPDATE Timelogs SET Name = 'Updated Title #1', LogDate = '2026-08-12' WHERE Id = '123456000000045018'

Delete

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

DELETE FROM Timelogs WHERE Id = '123456000000045018'

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Long	True	Unique identifier of the time log.
Name	String	False	Name of 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.