ISSUE CHANGES | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
Column | ISSUEID | ID | USERNAME | FIELD | CREATED | FROMVALUE | TOVALUE | INTERVAL | FROMSTRING | TOSTRING |
Type | BIGINT | BIGINT | VARCHAR | VARCHAR | TIMESTAMP | VARCHAR | VARCHAR | BIGINT | VARCHAR | VARCHAR |
Indexed | x | x | x |
It allows to access to the issue changes history for the issue 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 the name to use it in the query.The INTERVAL column is internally calculated (it does not belong to the Jira API) to provide the time spent in each value until it changed.
To get the time spent in each workflow status transition, the ISSUESTATUSTRANSTIONS should be instead since it is specially created for that.
...