How do I query JIRA to find issue attributes at a specified date?

Question

I have to export reports listing some attributes of JIRA issues at a specified date. So my query would be:

project = "XXX" AND fixVersion was "10.14.0.0" ON '2016-12-12 11:00'

And the result set would provide the status (mandatory) and other attributes (such as assignee) at the specified date.

For the moment, the result set provides me with the status at the current date, and not at the specified date.

How can I achieve that?

Any help really appreciated

Answer 1

It's not possible by default: JIRA always returns current/most recent values of the fields.

Though, there are workarounds:

1. You can programmatically run JQL query, expanding changelog items. Analyzing each change, you can find out value of interested field for the given date. Here is an example.
2. If you know some schedule of your reports (e.g. each Monday), you can configure cron job and periodically export issues for later processing.

Here are some related questions in Atlassian community:

• How do I get a snapshot of issues on a particular day using JQL (rest)?
• Snapshot of jira issues statuses on the specific date
• eazyBI - Snapshot of JIRA issues statuses on the specific dates