Query the history

How to query the history of Jira issues with Issue Matrix for Jira?

You can query the history of Jira issues and access the results effortlessly in a Matrix table. You can achieve this by leveraging the JQL history functions and the Extended JQL functionality of Issue Matrix for Jira. JQL history searches allow you to find all the issues that were in a certain state at a certain point in time or find all issues that were updated by a particular user between two dates. For more information on the various methods to go back in time and to check the history of Jira issues, you can refer to the article History searches in Jira.

By adding the Extended JQL to the equation, you can expand the history searches in the context of the current issue (currentIssue). You can find all the issues, which have the same properties in their history as the current issue. Check the JQL extension for system fields and the JQL extension for custom fields documents for supported fields.

You can use the following type of statements in combination with the currentIssue system and custom fields. Construct queries matching your use cases to query the history of issues in accordance with the current issue:

• CHANGED FROM

• CHANGED TO

• CHANGED BY

Examples

This will give you all issues at any time that had the status "OPEN" which was changed to the status of the current issue.

This will give you all the issues at any time that had their status changed from the current issue's status to DONE.

This will give you all the issues at any time that had their status changed from the current issue's status to DONE by the current issue's assignee.