IssueChangelogs
Provides a detailed history of changes made to issues, including field changes, timestamps, and authors.
Table Specific Information
You can search IssueChangelogs by using SQL and JQL (Jira Query Language).
Select
The add-in uses the Jira API to process some of the filters.
The add-in processes other filters within the add-in.
The available columns for server-side filtering for IssueChangelogs are IssueId, IssueKey, ProjectId, ProjectKey, ProjectName, and JQL. For example:
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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| 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. |