...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
select KEY(JQL.ISSUE) AS "Issue", ic.field AS "Field", ic.fromvalue, ic.tovalue, ic.fromstring, ic.tostring, formatdurationnatural(interval) as "Interval (Natural time)" from JQL join issuechanges ic on ic.issueid = iJQL.idissueid where JQL.QUERY = ' reporter = currentUser() and updated < -7d ' and ic.field='status' order by "Issue", "Field", ic.created |
| Issue | Field | FROMVALUE | TOVALUE | FROMSTRING | TOSTRING | Interval (Natural time) |
|---|---|---|---|---|---|---|
| DEMO-11 | status | 10000 | 3 | To Do | In Progress | 0m |
| DEMO-12 | status | 10000 | 3 | To Do | In Progress | 0m |
| DEMO-15 | status | 10000 | 3 | To Do | In Progress | 2d 4h 44m |
| DEMO-15 | status | 3 | 10001 | In Progress | Done | 2d 9h 52m |
| DEMO-16 | status | 10000 | 3 | To Do | In Progress | 3w 0d 0h 48m |
| DEMO-16 | status | 3 | 10001 | In Progress | Done | 1d 1h 48m |
| DEMO-17 | status | 10000 | 3 | To Do | In Progress | 10h 44m |
| DEMO-17 | status | 3 | 10001 | In Progress | Done | 3d 5h 52m |
| DEMO-18 | status | 10000 | 10001 | To Do | Done | 20h 30m |
| DEMO-19 | status | 10000 | 10001 | To Do | Done | 3d 20h 24m |
| DEMO-20 | status | 10000 | 10001 | To Do | Done | 5d 8h 59m |
| DEMO-21 | status | 10000 | 10001 | To Do | Done | 1w 0d 15h 37m |
| DEMO-22 | status | 10000 | 10001 | To Do | Done | 1w 3d 6h 57m |
| DEMO-23 | status | 10000 | 10001 | To Do | Done | 1w 5d 8h 35m |
...