MyTimelogs
Gets the time logs under a specific bug.
Select
This is a portal-level view. Columns that support the = operator:- BillStatus
- Date
- User
- ViewType
- ComponentType
For example, the following query is processed server side:
SELECT * FROM MyTimelogs WHERE User = '123450000123'
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. |
ProjectId | String | Time Log Project Id. |
ProjectName | String | Time Log Project Name. |
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 |