Page Comparison

...

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.

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?

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'

...