JDBC Driver for Jira

Build 22.0.8462

Worklogs

Create, modify, delete and query the available Worklogs in JIRA.

Table Specific Information

Select

You can query this table to retrieve worklogs of JIRA projects. The driver will use the Jira APIs to process filters based on the following columns and operators. The driver will execute other filters client-side. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

For example, the following query is processed server side:

SELECT * FROM Worklogs WHERE IssueId=10001

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

Columns

Name Type ReadOnly References SupportedOperators Platform Description
Id [KEY] String True = Common

The Id of the worklog.

IssueId [KEY] Integer False

Issues.Id

=,<>,>,>=,<,<=,IN,NOT IN Common

The issue Id of the worklog.

IssueKey String False

Issues.Key

=,IN,NOT IN Common

The key of the issue.

ProjectId Integer True

Projects.Id

=,IS,IS NOT,IN,NOT IN Common

The project Id of the worklog's issue.

ProjectName String True =,IS,IS NOT,IN,NOT IN Common

The project name of the worklog's issue.

IssueCreatedDate Datetime True =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN Common

The date the worklogs's issue was created.

IssueUpdatedDate Datetime True =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN Common

The date the worklogs's issue was last updated.

AuthorDisplayName String True

Users.DisplayName

=,!=,IS,IS NOT,IN,NOT IN Common

The display name of the author of the worklog.

UpdateAuthorDisplayName String True

Users.DisplayName

=,!=,IS,IS NOT,IN,NOT IN Common

The display name of the author who has updated the worklog.

Comment String False =,LIKE,NOT LIKE Common

The comment of the worklog.

Created Datetime True =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN Common

The date the worklog was created.

Updated Datetime True Common

The update date of the worklog.

VisibilityType String False Common

The visibility type of the worklog.

VisibilityValue String False Common

The visibility value of the worklog.

Started Datetime False Common

The start date of the worklog.

TimeSpent String False Common

The spent time of the worklog.

TimeSpentSeconds Long False Common

The time spent in seconds for the worklog.

AuthorAccountId String True

Users.AccountId

=,!=,IS,IS NOT,IN,NOT IN Cloud

The name of the author of the worklog.

UpdateAuthorAccountId String True

Users.AccountId

=,!=,IS,IS NOT,IN,NOT IN Cloud

The name of the author who has updated the worklog.

AuthorAccountKey String True

Users.Key

=,!=,IS,IS NOT,IN,NOT IN Server

The key of the author of the worklog.

AuthorAccountName String True

Users.Name

=,!=,IS,IS NOT,IN,NOT IN Server

The name of the author of the worklog.

UpdateAuthorAccountKey String True

Users.Key

=,!=,IS,IS NOT,IN,NOT IN Server

The key of the author who has updated the worklog.

UpdateAuthorAccountName String True

Users.Name

=,!=,IS,IS NOT,IN,NOT IN Server

The name of the author who has updated the worklog.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462