...
It allows to access to the issue changes history for the issue fitracked tracked by JIRA. You have to know the name used by JIRA to track the attribute (FIELD column value). Unfortunately those field names are documented nowhere as they belong to the private JIRA Java API. I.e: for the issue status attribute, the field name is: 'status'. You have to figure out out the name .
...
to
...
Getting the changed fields for any issue is something really trivial. So we have to cover a much more complex issue that users might face in the real World: the time between two consecutive changes, named INTERVAL by the Driver.
Please don't be overwhelmed due the complexity of this issue. Simply, we wanted to support the special INTERVAL column. This is a very particular use case supported by the Driver.
Warning |
---|
JIRA does not log data for issue creation as changes, so issues that did not modify the field after its creation are not included in the ISSUECHANGES table as well as the interval time in the current status is not shown either. |
Warning |
---|
In the 2.5.0 version a new column was supported: INTERVAL. A new table is supported for Issue Status Transitions since the 6.1.0 version. You should use it to get the interval that each issue remained in a particular state. |
Example:
Explore the status changes in my reported issues during last week
use it in the query.
Example: How to get re-assigned issues in DEMO project?
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
select KEY(JQL.ISSUE) AS "Issue", ic.field AS "Field", ic.fromvalue, ic.tovalue, ic.fromstring, ic.tostring, formatdurationnatural(interval c.issueid, c.username, c.created, usernamekey(c.fromValue) as "From user", usernamekey(c.toValue) as "Interval (Natural time)To user" from jql JQL join issuechanges icc on icc.issueid = JQLjql.issueid where JQLjql.QUERYquery = ' reporterproject = currentUser() and updated < -7dDEMO ' and ic.field='status' order by and "Issue", "Field", icc.createdfield = |
...
'assignee' |
ISSUEID |
---|
USERNAME |
---|
CREATED |
---|
From user |
---|
To user |
---|
...
10100 | admin | 2019-10-03 09:44:55.833 | null | admin |
10100 | admin | 2019-10-05 13:38:06.878 | admin | p |