JDBC Driver for Jira

Build 22.0.8462

Attachments

Query, insert and delete the available Attachments in JIRA.

Table Specific Information

Select

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 Attachments WHERE Id=10003

Retrieve attachments of an issue:

SELECT * FROM Attachments WHERE IssueId = '123' 

Use the JQL pseudocolumn for more complex filters on the issues to retrieve attachments from. For example, retrieve attachments of issues that were created after January 7th:

SELECT * FROM Attachments WHERE JQL = 'created > 2018-01-07' 

Insert

Upload an attachment to an issue.

INSERT INTO Attachments (FilePath, IssueKey) VALUES ('C:/Users/User/Desktop/info.txt', 'SSFSF-1')

INSERT INTO Attachments (ContentEncoded, Name, IssueKey) VALUES ('U29tZSBjb250ZW50IGhlcmU=', 'Uploaded File', 'SSFSF-1')

Delete

Remove an attachment uploaded to any issue by specifying the Id of the attachment

DELETE FROM Attachments WHERE Id=10003

Columns

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

The Id of the attachment.

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 False =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN Common

The date the attachment's issue was created.

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

The date the attachment's issue was last updated.

Filename String False Common

The filename of the attachment.

AuthorName String False Common

The name of the author of the attachment.

AuthorDisplayName String False

Users.DisplayName

Common

The display name of the author of the attachment.

Created Datetime False Common

The creation date of the attachment.

Size Integer False Common

The size of the attachment.

MimeType String False Common

The MIME type of the attachment.

Content String False Common

The URI of the actual attached file.

Thumbnail String False Common

The thumbnail of the attachment.

AuthorAccountId String False

Users.AccountId

Cloud

The account Id of the author of the attachment.

AuthorKey String False Server

The author key of the attachment.

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.

FilePath String

The path of the file to insert.

ContentEncoded String

BASE64 encoded content of the file to insert.

Name String

The name of the file to upload. Also the file extension should be specified.

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