Query, insert and delete the available Attachments in JIRA.
Table Specific Information
The adapter uses the JIRA API to process some of the filters.
The adapter processes other filters within the adapter.
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
The Id of the attachment.
The Id of the issue.
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.
The filename of the attachment.
The name of the author of the attachment.
The display name of the author of the attachment.
The creation date of the attachment.
The size of the attachment.
The MIME type of the attachment.
The URI of the actual attached file.
The thumbnail of the attachment.
The account Id of the author of the attachment.
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.
JQL (JIRA Query Language) allows you to build structured queries.
The path of the file to insert.
BASE64 encoded content of the file to insert.
The name of the file to upload. Also the file extension should be specified.