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.

Power BI Connector for Jira