JDBC Driver for Jira

Build 23.0.8839


Query, insert and delete the available Attachments in Jira.

Table Specific Information


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

The driver processes other filters within the driver.

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' 


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')


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

DELETE FROM Attachments WHERE Id = 10003


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

The Id of the attachment.

IssueId [KEY] Integer False


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

The Id of the issue.

IssueKey String False


=,<>,>,>=,<,<=,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



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



The account Id of the author of the attachment.

AuthorKey String False Server

The author key of the attachment.


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) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839