K1000 monthly report that includes outstanding un-closed reports from previous months.
I'm trying to create a monthly status report that includes all un-closed tickets from previous months.
This would allow me to track monthly progress and see what outstanding reports need to be addressed from previous months.
I've only been able to figure out how to create a monthly status report, but it does not include previous un-closed tickets.
Does anyone know how to do this?
This is what I've have for monthly reports so far (it includes the date created, category, and location):
SELECT HD_STATUS.NAME AS STATUS_NAME, HD_TICKET.CREATED, HD_CATEGORY.NAME AS CATEGORY, HD_TICKET.CUSTOM_FIELD_VALUE1, HD_TICKET.CUSTOM_FIELD_VALUE2 FROM HD_TICKET JOIN HD_STATUS ON (HD_STATUS.ID = HD_TICKET.HD_STATUS_ID) JOIN HD_CATEGORY ON (HD_CATEGORY.ID = HD_TICKET.HD_CATEGORY_ID) WHERE (HD_TICKET.HD_QUEUE_ID = 14) AND ((HD_TICKET.CREATED > '2016-06-01 11:03:42') AND (HD_TICKET.CREATED < '2016-06-30 11:03:42')) ORDER BY STATUS_NAME