Worklogs
Provides full access to Jira worklogs. Supports creating, updating, deleting, and querying logged work hours on issues.
Table Specific Information
Select
You can query this table to retrieve worklogs of Jira projects. The cmdlet will use the Jira APIs to process filters based on the following columns and operators. The cmdlet will execute other filters client-side. The below example queries are processed server side.
To retrieve worklogs linked to a specific issue, query the
Worklogs table by specifying either the IssueId or IssueKey column.
SELECT * FROM Worklogs WHERE IssueId = 123
To retrieve worklogs linked to issues within a specific project, query the
Worklogs table by specifying either the ProjectId or ProjectName column.
SELECT * FROM Worklogs WHERE ProjectId = 10100
Insert
IssueId, Started, and TimeSpentSeconds are required to insert. The following query logs work done for an issue:
INSERT INTO Worklogs (IssueId, Started, TimeSpentSeconds) VALUES (10003, '2017-03-20 20:00:00', 10000)
Update
Both the worklog Id and IssueId are required to modify the worklog:
UPDATE Worklogs SET TimeSpentSeconds = 200000 WHERE Id = 10602 AND IssueId = 10003
Delete
Delete a worklog of an issue by providing the Id and IssueId:
DELETE FROM Worklogs WHERE Id = 10602 AND IssueId = 10003
GetDeleted
This retrieves Ids of the deleted worklogs:
GETDELETED FROM Worklogs
Columns
| Name | Type | ReadOnly | References | SupportedOperators | Platform | Description |
| Id [KEY] | String | True | = | Common |
The unique identifier of the worklog entry used to distinguish it from all other worklogs in the system. | |
| IssueId [KEY] | Integer | False |
Issues.Id | =,<>,>,>=,<,<=,IN,NOT IN | Common |
The internal numeric ID of the Jira issue associated with this worklog entry. This links the worklog to a specific issue. |
| IssueKey | String | False |
Issues.Key | =,IN,NOT IN | Common |
The human-readable key of the Jira issue (such as 'ABC-123') that this worklog entry pertains to. |
| ProjectId | Integer | True |
Projects.Id | =,IS,IS NOT,IN,NOT IN | Common |
The numeric ID of the project to which the issue belongs. This helps associate the worklog with a broader context. |
| ProjectName | String | True | =,IS,IS NOT,IN,NOT IN | Common |
The name of the project that the associated issue and worklog entry belong to. | |
| IssueCreatedDate | Datetime | True | =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common |
The date and time when the issue associated with this worklog was originally created. | |
| IssueUpdatedDate | Datetime | True | =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common |
The date and time when the issue associated with this worklog was last updated. | |
| AuthorDisplayName | String | True |
Users.DisplayName | =,!=,IS,IS NOT,IN,NOT IN | Common |
The display name of the user who initially created the worklog entry. |
| UpdateAuthorDisplayName | String | True |
Users.DisplayName | Common |
The display name of the user who most recently updated or modified the worklog entry. | |
| Comment | String | False | LIKE,NOT LIKE | Common |
The free-text comment or description added by the user to describe the work performed during this logged time. | |
| Created | Datetime | True | =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common |
The date and time when the worklog entry was created in Jira. | |
| Updated | Datetime | True | Common |
The date and time when the worklog entry was last modified. | ||
| VisibilityType | String | False | Common |
The category of restriction that controls who can view this worklog entry, such as role-based or group-based visibility. | ||
| VisibilityValue | String | False | Common |
The specific value used to enforce visibility restrictions, such as the name of the user role or group allowed to view the entry. | ||
| Started | Datetime | False | Common |
The exact date and time when the user began working, according to this logged work entry. | ||
| TimeSpent | String | False | Common |
The total time spent on the issue, as logged in this worklog entry, formatted as a string (such as '3h 15m'). | ||
| TimeSpentSeconds | Long | False | Common |
The total time spent on the issue in seconds, useful for precise calculations and aggregations. | ||
| AuthorAccountId | String | True |
Users.AccountId | =,!=,IS,IS NOT,IN,NOT IN | Cloud |
The Atlassian account ID of the user who created the worklog, used for cross-product user identification. |
| UpdateAuthorAccountId | String | True |
Users.AccountId | Cloud |
The Atlassian account ID of the user who last updated the worklog, used for consistent tracking of changes. | |
| AuthorAccountKey | String | True |
Users.Key | Server |
The legacy user key of the person who created the worklog entry. This field can not be supported in newer Jira versions. | |
| AuthorAccountName | String | True |
Users.Name | =,!=,IS,IS NOT,IN,NOT IN | Server |
The legacy username of the worklog creator. This value can be deprecated in favor of accountId. |
| UpdateAuthorAccountKey | String | True |
Users.Key | Server |
The legacy user key of the person who last updated the worklog entry. This value can be deprecated. | |
| UpdateAuthorAccountName | String | True |
Users.Name | Server |
The legacy username of the user who last modified the worklog. This field can not be supported in newer Jira versions. | |
| ItemURL | String | True |
A direct URL to view the specific worklog entry in the Jira UI, useful for navigation or reporting. |