MyTimelogs
Gets the time logs for the current user for provided module type.
Select
This is a portal-level view.Module is a required field to access this view. Accepted values for this field are: general, issue, task.
- Date column supports '>,>=,=,<,<=' operators
For example, the following query is processed server side:
SELECT * FROM MyTimelogs WHERE Module = 'task' AND Date = '2026-01-01'Querying MyTimelogs without date filter will return data for only the current month:
SELECT * FROM MyTimelogs where Module = 'task'
Columns
| Name | Type | Description |
| Id [KEY] | Long | Unique identifier of the time log. |
| Name | String | Name of the time log entry. |
| ModuleId | Long | Id of the module associated with the time log entry. |
| ModuleName | String | Name of the module associated with the time log entry. |
| ModulePrefix | String | Prefix of the module associated with the time log entry. |
| ModuleType | String | Type of the module associated with the time log entry. |
| LogDate | Date | Date of the time log in ISO format (YYYY-MM-DD). |
| Notes | String | Additional notes on the time log. |
| LogNotes | String | Log notes associated with the time log. |
| LogHour | String | Logged hours in HH:MM format. |
| BillingStatus | String | Billing status of the time log. |
| StartTime | String | Start time of the work. |
| EndTime | String | End time of the work. |
| CreatedTime | Datetime | Created time of the time log in ISO format. |
| LastModifiedTime | Datetime | Last modified time of the time log in ISO format. |
| OwnerZpuid | Long | Zoho Projects User ID (ZPUID) of the time log owner. |
| OwnerZuid | Long | Zoho User ID (ZUID) of the time log owner. |
| OwnerFirstName | String | First name of the time log owner. |
| OwnerLastName | String | Last name of the time log owner. |
| OwnerName | String | Display name of the time log owner. |
| OwnerEmail | String | Email address of the time log owner. |
| OwnerImageUrl | String | Profile image URL of the time log owner. |
| AddedByZpuid | Long | Zoho Projects User ID (ZPUID) of the time log creator. |
| AddedByZuid | Long | Zoho User ID (ZUID) of the time log creator. |
| AddedByFirstName | String | First name of the time log creator. |
| AddedByLastName | String | Last name of the time log creator. |
| AddedByName | String | Display name of the time log creator. |
| AddedByEmail | String | Email address of the time log creator. |
| ProjectId | Long | Unique identifier of the project. |
| ProjectName | String | Name of the project. |
| ApprovalStatus | String | Approval status of the time log.
The allowed values are Approved, Unapproved, Rejected. |
| ApproverZpuid | Long | Zoho Projects User ID (ZPUID) of the approver. |
| ApproverZuid | Long | Zoho User ID (ZUID) of the approver. |
| ApproverName | String | Display name of the approver. |
| ApproverEmail | String | Email address of the approver. |
| ApprovalTime | String | Time of approval. |
| CostAmount | Decimal | Cost amount of the time log. |
| CostFormattedAmount | String | Formatted cost amount of the time log. |
| CostCurrencyCode | String | Currency code for the time log cost. |
| CostCurrencyId | String | Currency id for the time log cost. |
| CostRatePerHourAmount | Decimal | Cost rate per hour amount. |
| CostRatePerHourFormattedAmount | String | Formatted cost rate per hour. |
| CostRatePerHourCurrencyCode | String | Currency code for the cost rate per hour. |
| CostRatePerHourCurrencyId | String | Currency id for the time log cost. |
| Module | String | The type of the module.
The allowed values are issue, task, general. |
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. |