Comments
Create, modify, delete and query the available Comment types in Jira.
テーブル固有の情報
Select
このテーブルをクエリして、すべての課題にポストされたすべてのコメントを取得できます。
本製品 はJira API を使用して一部のフィルタを処理します。
本製品 は他のフィルタを本製品 内で処理します。
例えば、次のクエリはサーバー側で処理されます。
SELECT * FROM Comments
特定の課題にポストされたコメントを取得することもできます。
SELECT * FROM Comments WHERE IssueId = 10003
さらに、ORDER BY 句でCreated カラムを使用できます。
SELECT * FROM Comments WHERE IssueId = 10003 ORDER BY Created DESC
Insert
ログインユーザーとしてコメントをポストします。IssueId およびBody が必須です。
INSERT INTO Comments (IssueId, Body) VALUES ('10003', 'Test Comment')
Update
コメントの内容のみが更新可能です。UPDATE にはIssueId も必要です。
UPDATE Comments SET Body = 'Updated Comment' WHERE Id = 10202 AND IssueId = 10003
Delete
Id およびIssueId を入力して、課題にポストされたコメントを削除します。
DELETE FROM Comments WHERE Id = 10202 AND IssueId = 10003
Columns
Name | Type | ReadOnly | References | SupportedOperators | Platform | Description |
Id [KEY] | Integer | True | = | Common |
The Id of the comment. | |
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 | True | =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common |
The date the comment's issue was created. | |
IssueUpdatedDate | Datetime | True | =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common |
The date the comment's issue was last updated. | |
AuthorDisplayName | String | True |
Users.DisplayName | Common |
The display name of the author who made the comment. | |
AuthorEmail | String | True |
Users.EmailAddress | Common |
The email address of the author who made the comment. | |
UpdateDisplayName | String | True |
Users.DisplayName | Common |
The display name of the author who changed the comment. | |
UpdateAuthorEmail | String | True |
Users.EmailAddress | Common |
The email address of the author who edited the comment. | |
Body | String | False | Common |
The body of the comment. | ||
RenderedBody | String | True | Common |
The rendered body of the comment. | ||
Created | Datetime | True | Common |
The date the comment was created. | ||
Updated | Datetime | True | Common |
The date the comment was updated. | ||
VisibilityType | String | False | Common |
The visibility type of the comment. | ||
VisibilityValue | String | False | Common |
The visibility value of the comment. | ||
AuthorAccountName | String | True | Server |
The name of the author who made the comment. | ||
AuthorAccountKey | String | True | Server |
The key of the author who made the comment. | ||
UpdateAuthorAccountKey | String | True | Server |
The Id of the author who edited the comment. | ||
UpdateAuthorAccountName | String | True | Server |
The name of the author who edited the comment. | ||
AuthorAccountId | String | True |
Users.AccountId | Cloud |
The name of the author who made the comment. | |
UpdateAuthorAccountId | String | True |
Users.AccountId | Cloud |
The Id of the author who edited the comment. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
JQL | String |
JQL (Jira Query Language) allows you to build structured queries. |