Provides a detailed history of changes made to issues, including field changes, timestamps, and authors.

View-Specific Information

You can query IssueChangelogs by using a Jira Query Language (JQL) query as a filter.

SELECT

The connector uses the Jira API to process filters based on the IssueId, IssueKey, ProjectId, ProjectKey, ProjectName, and JQL columns. The connector processes all other filters client-side.

For example, the following queries are processed server-side:

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	Users.AccountId		Cloud	The unique identifier of the user account in Atlassian systems that performed the change, ensuring consistent identification across products.
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.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data 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.