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. |