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.