Attachments

Columns

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

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.

Last updated