BugTimelogs
Gets the time logs under a specific bug.
Select
- BugId is required to retrieve Bug Time Logs.
SELECT * FROM BugTimelogs WHERE BugId = '123456000000045005'
Insert
To add a Bug TimeLog specify the BugId and Follower fields.
INSERT INTO BugTimelogs (BugId, LogDate, BillStatus, HoursDisplay, Notes)
VALUES ('123456000000045005', '2022-03-03', 'Non Billable', '01:20', 'This is a test timelog')
Update
To update a Bug TimeLog specify the BugId and Id fields.
UPDATE BugTimelogs SET Notes = 'This is an updated SQL Note' WHERE BugId = '165818000000045005' AND Id = '123456000000044025'
Delete
Bug TimeLogs can be deleted by providing the BugId and Id and issuing a DELETE statement.
DELETE FROM BugTimelogs WHERE BugId = '123456000000045005' AND Id = '123456000000044025'
Columns
| Name | Type | ReadOnly | Description |
| BugId [KEY] | String | False |
Bug Id. |
| Id [KEY] | String | False |
Bug Time Log Id. |
| AddedByName | String | False |
Bug Time Log Added By Name. |
| AddedByZpuid | String | False |
Bug Time Log Added By ZPUID. |
| AddedByZuid | Long | False |
Bug Time Log Added By ZUID. |
| ApprovalStatus | String | False |
Bug Time Log Approval Status. |
| ApproverName | String | False |
Bug Time Log Approver Name. |
| BillStatus | String | False |
Bug Time Log Bill Status. The allowed values are Billable, Non Billable. |
| BugTitle | String | False |
Bug Time Log Bug Title. |
| CreatedDate | Date | False |
Bug Time Log Created Date. |
| CreatedDateTime | Datetime | False |
Bug Time Log Created Date Time. |
| Hours | Integer | False |
Bug Time Log Hours. |
| Minutes | Integer | False |
Bug Time Log Minutes. |
| HoursDisplay | String | False |
Bug Time Log Hours Display. |
| LastModifiedDate | Date | False |
Bug Time Log Last Modified Date. |
| LastModifiedDateTime | Datetime | False |
Bug Time Log Last Modified Date Time. |
| LinkSelfUrl | String | False |
Bug Time Log Link Self Url. |
| LogDate | Date | False |
Bug Time Log Date. |
| LogDateTime | Datetime | False |
Bug Time Log Date Time. |
| Notes | Unknown | False |
Bug Time Log Notes. |
| OwnerId | String | False |
Bug Time Log Owner Id. |
| OwnerName | String | False |
Bug Time Log Owner Name. |
| TotalMinutes | Integer | False |
Bug Time Log Total Minutes. |