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