Attachments

Provides access to issue attachments in Jira. Supports querying, inserting, and deleting file attachments associated with issues.

Table Specific Information

Select

The add-in uses the Jira API to process some of the filters.

The add-in processes other filters within the add-in.

For example, the following queries are processed server side:

SELECT * FROM Attachments WHERE Id = 10003

To retrieve attachments linked to a specific issue, query the Attachments table by specifying either the IssueId or IssueKey column.

SELECT * FROM Attachments WHERE IssueId = 123

To retrieve attachments linked to issues within a specific project, query the Attachments table by specifying either the ProjectId or ProjectName column.

SELECT * FROM Attachments WHERE ProjectId = 10100

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 unique numeric identifier of the attachment within the Jira system.
IssueId [KEY]	Integer	False	Issues.Id	=,<>,>,>=,<,<=,IN,NOT IN	Common	The internal identifier of the issue that the attachment is associated with.
IssueKey	String	False	Issues.Key	=,<>,>,>=,<,<=,IN,NOT IN	Common	The unique key that identifies the issue related to the attachment, such as 'JIRA-101'.
ProjectId	Integer	True	Projects.Id	=,IS,IS NOT,IN,NOT IN	Common	The numeric identifier of the project that contains the issue to which the attachment is linked.
ProjectName	String	True		=,IS,IS NOT,IN,NOT IN	Common	The name of the project that includes the issue where this attachment was added.
IssueCreatedDate	Datetime	False		=,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN	Common	The timestamp indicating when the issue associated with this attachment was originally created.
IssueUpdatedDate	Datetime	False		=,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN	Common	The timestamp of the most recent update to the issue related to this attachment.
Filename	String	False			Common	The original name of the uploaded file, including the file extension.
AuthorName	String	False			Common	The username of the user who uploaded the attachment.
AuthorDisplayName	String	False	Users.DisplayName		Common	The full display name of the user who uploaded the attachment, typically shown in the Jira UI.
Created	Datetime	False			Common	The date and time when the attachment was added to the issue.
Size	Integer	False			Common	The total file size of the attachment, in bytes.
MimeType	String	False			Common	The Multipurpose Internet Mail Extensions (MIME) type of the file, used to indicate the file format such as 'application/pdf' or 'image/jpeg'.
Content	String	False			Common	The direct Uniform Resource Identifier (URI) to access or download the full content of the attachment from Jira.
Thumbnail	String	False			Common	The URI to a smaller, thumbnail version of the attachment image if available. Typically used for previews.
AuthorAccountId	String	False	Users.AccountId		Cloud	The unique account ID of the user who uploaded the attachment. This ID is consistent across the Atlassian platform.
AuthorKey	String	False			Server	An internal Jira user key that uniquely identifies the user who added 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	A field for specifying a Jira Query Language (JQL) expression to filter attachments by issue context when querying.
FilePath	String	The absolute path to the file on the local machine to be uploaded as an attachment.
ContentEncoded	String	The content of the file to upload, encoded in BASE64 format. Used in scenarios where direct file access is not possible.
Name	String	The name to assign to the uploaded file, including its extension, which will appear in the issue's attachment list.