SSIS Components for Jira

Build 24.0.9062

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062