ADO.NET Provider for Jira

Build 22.0.8479

IssueChangelogs

Query the available IssueChangelogs in JIRA.

テーブル固有の情報

SQL とJQL (JIRA Query Language) を使用して、IssueChangelogs を検索できます。

Select

本製品 はJira API を使用して一部のフィルタを処理します。

本製品 は他のフィルタを本製品 内で処理します。 SupportEnhancedSQL をfalse に設定することで、クエリのクライアント側の実行をオフにできます。

IssueChangelogs で使用可能なカラムは、IssueId、IssueKey、およびJQL です。次に例を示します。

SELECT * FROM IssueChangelogs WHERE IssueId<>10022

Columns

Name Type References SupportedOperators Platform Description
HistoryId Integer Common The Id of the change.
IssueId Integer

Issues.Id

=,<>,>,>=,<,<=,IN,NOT IN Common The Id of the issue.
IssueKey String

Issues.Key

=,<>,>,>=,<,<=,IN,NOT IN Common The key of the issue.
Created Datetime Common The creation date of the change.
IssueCreatedDate Datetime =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN Common The date the change's issue was created.
IssueUpdatedDate Datetime =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN Common The date the change's issue was last updated.
ItemField String Common The item field of the change.
ItemFieldType String Common The item field type of the change.
ItemFrom String Common The item the issue changed from.
ItemFromString String Common The description of the item the issue changed from.
ItemTo String Common The item the issue changed to.
ItemToString String Common The description of the item the issue changed to.
AuthorDisplayName String Common The display name of the author who has updated the change.
AuthorAccountId String Cloud The author name of the change.
AuthorName String Cloud The author name of the change.
AuthorAccountKey String Server The key of the author of the change.
AuthorAccountName String Server The name of the author who has updated the change.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
JQL String JQL (JIRA Query Language) allows you to build structured queries.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479