IssueChangelogs
Query the available IssueChangelogs in Jira.
テーブル固有の情報
SQL とJQL (Jira Query Language) を使用して、IssueChangelogs を検索できます。
Select
connector はJira API を使用して一部のフィルタを処理します。
connector は他のフィルタをconnector 内で処理します。
IssueChangelogs のサーバー側のフィルタリングで使用可能なカラムは、IssueId、IssueKey、ProjectId、ProjectKey、ProjectName およびJQL です。次に例を示します。
SELECT * FROM IssueChangelogs WHERE IssueId<>10022 SELECT * FROM IssueChangelogs WHERE ProjectKey = 'PRJ'
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. | ||
| ProjectId | Integer |
Projects.Id | =,!=,IS,IS NOT,IN,NOT IN | Common | The project Id of the issue. |
| ProjectKey | String |
Projects.Key | =,!=,IS,IS NOT,IN,NOT IN | Common | The project key of the issue. |
| ProjectName | String | =,!=,IS,IS NOT,IN,NOT IN | Common | The project name of the issue. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| JQL | String | JQL (Jira Query Language) allows you to build structured queries. |