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.
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. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
Date | Date | Time Log Date. |
User | String | Time Log User. |
ViewType | String | Time Log View Type.
The allowed values are day, week, month. |
ComponentType | String | Time Log Component Type.
The allowed values are bug, task, general. |