MyTimelogs

Gets the time logs under a specific bug.

Select

This is a portal-level view. Columns that support the = operator:

Columns that support the >,>=,=,<,<= operators:

For example, the following queries are processed server side:

SELECT * FROM MyTimelogs WHERE User = '123450000123'

SELECT * FROM MyTimelogs WHERE Date > '2024-01-01'

SELECT * FROM MyTimelogs WHERE LastModifiedDate > '2024-01-01'

Querying MyTimeLogs without filters will return data for only the current month:

SELECT * FROM MyTimelogs


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.
ProjectId	String	Time Log Project Id.
ProjectName	String	Time Log Project Name.
Date	Date	Time Log Date.
User	String	Time Log User.
ComponentType	String	Time Log Component Type. The allowed values are bug, task, general.