| 44 | report query as: |
| 45 | {{{ |
| 46 | select id, summary, ticket.time, |
| 47 | a.time as accepted_datetime, |
| 48 | c.time as closed_datetime, |
| 49 | c.author as Closer |
| 50 | from ticket |
| 51 | left join ( |
| 52 | SELECT ticket, author, newvalue AS status, max(time) AS time |
| 53 | FROM ticket_change WHERE field = 'status' and status = 'accepted' |
| 54 | GROUP BY ticket, newvalue |
| 55 | ) AS a on (a.ticket = ticket.id and a.status = "accepted") |
| 56 | left join ( |
| 57 | SELECT ticket, author, newvalue AS status, max(time) AS time |
| 58 | FROM ticket_change WHERE field = 'status' and status = 'closed' |
| 59 | GROUP BY ticket, newvalue |
| 60 | ) AS c on (c.ticket = ticket.id and c.status = "closed") |
| 61 | }}} |
| 62 | [[Image(report.png)]] |