Gets the time logs under a specific task.

Select

• TaskId is required to retrieve Task Time Logs.

For example, the following query is processed server side:

SELECT * FROM TaskTimelogs WHERE TaskId = '123456000000045005'

Insert

To create a new Task Timelog you can specify the following fields:

• TaskId
• BillStatus
• Notes
• HoursDisplay
• LogDate
• OwnerId

INSERT INTO TaskTimelogs (TaskId, LogDate, BillStatus, HoursDisplay, Notes) " +
VALUES ('123456000000040013', '2022-03-03', 'Non Billable', '01:20', 'This is a test timelog')

Update

To update a Task TimeLog specify the TaskId and Id fields.

UPDATE TaskTimelogs
	SET Notes = 'This is an updated SQL Note'
	WHERE TaskId = '165818000000040013' AND Id = '165818000000045001'

Delete

Task TimeLogs can be deleted by providing the TaskId and Id and issuing a DELETE statement.

DELETE FROM TaskTimelogs WHERE TaskId = '123456000000045005' AND Id = '123456000000044025'

Columns

Name	Type	ReadOnly	Description
TaskId [KEY]	String	False	Task Id.
Id [KEY]	String	False	Task Time Log Id.
AddedByName	String	False	Task Time Log Added By Name.
AddedByZpuid	String	False	Task Time Log Added By Zpuid.
AddedByZuid	Long	False	Task Time Log Added By Zuid.
ApprovalStatus	String	False	Task Time Log Approval Status.
ApproverName	String	False	Task Time Log Approver Name.
BillStatus	String	False	Task Time Log Bill Status. 使用できる値は次のとおりです。Billable, Non Billable
CreatedDate	Date	False	Task Time Log Created Date.
CreatedDateTime	Datetime	False	Task Time Log Created Date Time.
StartTime	Datetime	False	Task Time Log Start Time.
EndTime	Datetime	False	Task Time Log End Time.
Notes	String	False	Task Time Log Notes.
HoursDisplay	String	False	Task Time Log Hours Display.
Hours	Integer	False	Task Time Log Hours.
Minutes	Integer	False	Task Time Log Minutes.
IsParent	Boolean	False	Task Time Log Is Parent.
IsSubTask	Boolean	False	Task Time Log Is Sub Task.
LastModifiedDate	Date	False	Task Time Log Last Modified Date.
LastModifiedDateTime	Datetime	False	Task Time Log Last Modified Date Time.
LinkSelfUrl	String	False	Task Time Log Link Self Url.
LogDate	Date	False	Task Time Log Date.
LogDateTime	Datetime	False	Task Time Log Date Time.
OwnerId	String	False	Task Time Log Owner Id.
OwnerName	String	False	Task Time Log Owner Name.
SubTaskLevel	String	False	Task Time Log Sub Task Level.
TaskName	String	False	Task Time Log Task Name.
TaskListId	Long	False	Task Time Log Task List Id.
TaskListName	String	False	Task Time Log Task List Name.
TotalMinutes	Integer	False	Task Time Log Total Minutes.