Report including Incident created, status changed and previous status changed date columns
SummaryHelp required with Custom Script to enable date in status reporting requirement
1. I have built a report that uses the Incidents table to get the reference number and date created fields for every incident.
2. I have then joined the incidents table to the transactions table, added a filter to just look for transaction type of 'Created' and 'Status Changed' and added the field transactions.created to show the date/time when the transaction happened. This gives me multiple rows for each incident which is what I require (one for each status change).
3. I've then linked to the incident statuses table and added the inc_statuses.status_id field to show the name of the status change for the transaction.