Excel Add-In for Zoho Projects

Build 23.0.8839

Timelogs

Gets the time logs under a specific bug.

Select

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

For example, the following query is processed server side:
SELECT * FROM ProjectLayouts

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.

使用できる値は次のとおりです。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.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
Date Date Time Log Date.
User String Time Log User.
ViewType String Time Log View Type.

使用できる値は次のとおりです。day, week, month

ComponentType String Time Log Component Type.

使用できる値は次のとおりです。bug, task, general

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