/build/static/layout/Breadcrumb_cap_w.png

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







0 Comments   [ + ] Show comments

Answers (1)

Posted by: Hobbsy 8 years ago
Red Belt
1

It sounds to me that you want to capture all tickets not in a "closed" state and then order them as you wish. You can create this report pretty easily with the reporting wizard. In the filters section just select all tickets where the status is not equal to your closed status. In my case I had two closed status, namely closed and resolved


SELECT HD_TICKET.CREATED, HD_TICKET.SUMMARY, HD_TICKET.ID  FROM HD_TICKET  JOIN HD_STATUS ON (HD_STATUS.ID = HD_TICKET.HD_STATUS_ID) WHERE (HD_TICKET.HD_QUEUE_ID = 21) AND ((HD_STATUS.NAME != 'Resolved') AND (HD_STATUS.NAME != 'Closed'))  ORDER BY CREATED

This results in a report of all open tickets

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ