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.

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.