Attachments
Query, insert and delete the available Attachments in Jira.
テーブル固有の情報
Select
本製品 はJira API を使用して一部のフィルタを処理します。
本製品 は他のフィルタを本製品 内で処理します。
例えば、次のクエリはサーバー側で処理されます。
SELECT * FROM Attachments WHERE Id = 10003
課題の添付ファイルを取得します。
SELECT * FROM Attachments WHERE IssueId = '123'
添付ファイルを取得する課題のより複雑なフィルタリングには、JQL 疑似カラムを使用します。例えば、以下は1月7日以降に作成された課題の添付ファイルを取得します。
SELECT * FROM Attachments WHERE JQL = 'created > 2018-01-07'
Insert
課題に添付ファイルをアップロードします。
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
添付ファイルのID を指定して、課題にアップロードされた添付ファイルを削除します。
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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
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. |