JDBC Driver for Jira

Build 22.0.8462

Comments

Create, modify, delete and query the available Comment types in JIRA.

Table Specific Information

Select

You can query this table to retrieve comments posted on all issues.

The driver uses the Jira API to process some of the filters.

The driver processes other filters within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

For example, the following queries are processed server side:

SELECT * FROM Comments

You can also retrieve comments posted on a specific issue.

SELECT * FROM Comments WHERE IssueId=10003

Additionally, the Created column can be used in the ORDER BY clause:

SELECT * FROM Comments WHERE IssueId=10003 ORDER BY Created DESC

Insert

Post a comment as the logged in user. IssueId and Body are required.

INSERT INTO Comments(IssueId,Body) VALUES ('10003','Test Comment')

Update

Only the body of the comment can be updated. The IssueId is required for an update as well.

UPDATE Comments SET Body='Updated Comment' WHERE Id=10202 AND IssueId=10003

Delete

Delete a comment posted in an issue by providing the Id and IssueId

DELETE FROM Comments WHERE Id=10202 AND IssueId=10003

Columns

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

The Id of the comment.

IssueId [KEY] Integer False

Issues.Id

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

The Id of the issue.

IssueKey String False

Issues.Key

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

The key of the issue.

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

The date the comment's issue was created.

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

The date the comment's issue was last updated.

AuthorDisplayName String True

Users.DisplayName

Common

The display name of the author who made the comment.

AuthorEmail String True

Users.EmailAddress

Common

The email address of the author who made the comment.

UpdateDisplayName String True

Users.DisplayName

Common

The display name of the author who changed the comment.

UpdateAuthorEmail String True

Users.EmailAddress

Common

The email address of the author who edited the comment.

Body String False Common

The body of the comment.

RenderedBody String True Common

The rendered body of the comment.

Created Datetime True Common

The date the comment was created.

Updated Datetime True Common

The date the comment was updated.

VisibilityType String False Common

The visibility type of the comment.

VisibilityValue String False Common

The visibility value of the comment.

AuthorAccountName String True Server

The name of the author who made the comment.

AuthorAccountKey String True Server

The key of the author who made the comment.

UpdateAuthorAccountKey String True Server

The Id of the author who edited the comment.

UpdateAuthorAccountName String True Server

The name of the author who edited the comment.

AuthorAccountId String True

Users.AccountId

Cloud

The name of the author who made the comment.

UpdateAuthorAccountId String True

Users.AccountId

Cloud

The Id of the author who edited the comment.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
JQL String

JQL (JIRA Query Language) allows you to build structured queries.

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