ODBC Driver for Zoho Projects

Build 24.0.9060

Timelogs

Gets the time logs under a specific bug.

Select

This is a project-level view. Columns that support the = operator:
  • BillStatus
  • User
  • ComponentType

Columns that support the >,>=,=,<,<= operators:
  • Date
  • LastModifiedDate

For example, the following queries are processed server side:
SELECT * FROM Timelogs WHERE Date > '2024-01-01'

SELECT * FROM Timelogs WHERE LastModifiedDate > '2024-01-01'
Querying Timelogs without filters will return data for only the current month:
SELECT * FROM Timelogs

Columns

Name Type Description
Id [KEY] String Time Log Id.
AddedByName String Time Log Added By Name.
AddedByZpuid String Time Log Added By Zpuid.
AddedByZuid Long Time Log Added By Zuid.
ApprovalStatus String Time Log Approval Status.
ApproverName String Time Log Approver Name.
BillStatus String Time Log Bill Status.

The allowed values are all, billable, non billable.

CreatedDate Date Time Log Created Date.
CreatedDateTime Datetime Time Log Created Date Time.
StartTime Datetime Time Log Start Time.
EndTime Datetime Time Log End Time.
Notes String Time Log Notes.
HoursDisplay String Time Log Hours Display.
Hours Integer Time Log Hours.
Minutes Integer Time Log Minutes.
IsParent Boolean Time Log Is Parent.
IsSubTask Boolean Time Log Is Sub Task.
LastModifiedDate Date Time Log Last Modified Date.
LastModifiedDateTime Datetime Time Log Last Modified Date Time.
LinkSelfUrl String Time Log Link Self Url.
LogDate Date Time Log Date.
LogDateTime Datetime Time Log Date Time.
OwnerId String Time Log Owner Id.
OwnerName String Time Log Owner Name.
SubTaskLevel String Time Log Sub Task Level.
TaskName String Time Log Task Name.
TaskListId Long Time Log Task List Id.
TaskListName String Time Log Task List Name.
TotalMinutes Integer Time Log Total Minutes.
Date Date Time Log Date.
User String Time Log User.
ComponentType String Time Log Component Type.

The allowed values are bug, task, general.

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