IssueChangelogs
Provides a detailed history of changes made to issues, including field changes, timestamps, and authors.
テーブル固有の情報
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 [KEY] | Integer | Common | The unique identifier of the changelog entry that records a specific modification made to an issue, used to differentiate individual changes in the issue history. | ||
| ItemField [KEY] | String | Common | The name of the specific field that was changed in the issue, such as priority, assignee, or status. | ||
| IssueId | Integer |
Issues.Id | =,<>,>,>=,<,<=,IN,NOT IN | Common | The internal numeric identifier of the issue for which the changelog entry applies, used to relate the change to the correct issue. |
| IssueKey | String |
Issues.Key | =,<>,>,>=,<,<=,IN,NOT IN | Common | The human-readable key of the issue (such as 'JIRA-123') that was updated in the changelog entry. |
| Created | Datetime | Common | The exact date and time when the change was recorded in the issue history. | ||
| IssueCreatedDate | Datetime | =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common | The timestamp indicating when the issue itself was originally created, regardless of the change. | |
| IssueUpdatedDate | Datetime | =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common | The timestamp marking the most recent update to the issue at the time of the changelog entry. | |
| ItemFieldType | String | Common | The type of field that was changed, such as string, user, option, or date, providing context for how the data is handled. | ||
| ItemFrom | String | Common | The internal or stored value of the field before the change occurred, useful for identifying the exact prior state. | ||
| ItemFromString | String | Common | A human-readable version of the field's value before the update, shown as it would appear in the Jira UI. | ||
| ItemTo | String | Common | The internal or stored value of the field after the change was applied. | ||
| ItemToString | String | Common | A human-readable version of the field's new value after the change, shown as it would appear in the Jira UI. | ||
| AuthorDisplayName | String | Common | The full display name of the user who made the change, typically shown in the Jira UI. | ||
| AuthorAccountId | String | Cloud | The unique identifier of the user account in Atlassian systems that performed the change, ensuring consistent identification across products. | ||
| AuthorName | String | Cloud | The legacy username or short name of the user who made the change, used in older Jira configurations. | ||
| AuthorAccountKey | String | Server | The internal key identifying the account that made the change, used to link user actions to account metadata. | ||
| AuthorAccountName | String | Server | The full account name of the user who performed the update, often used in directory integrations or audit trails. | ||
| ProjectId | Integer |
Projects.Id | =,!=,IS,IS NOT,IN,NOT IN | Common | The unique numeric identifier of the project associated with the issue, used for internal references and queries. |
| ProjectKey | String |
Projects.Key | =,!=,IS,IS NOT,IN,NOT IN | Common | The readable key of the project (such as 'PROJ') that the issue belongs to, used in URLs and filters. |
| ProjectName | String | =,!=,IS,IS NOT,IN,NOT IN | Common | The descriptive name of the project that contains the issue, providing context for where the issue resides. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| JQL | String | Jira Query Language (JQL) allows users to filter changelog entries based on conditions like project, user, field, or date ranges. |