K1000 Ticket Report Skips A Particular TicketID#
I am trying to run a ticket report for All Ticket from a certain date range. It runs successfully but for some reason it skips a particular ticket in the range, Ticket#4284. My auditors need the report and I am not sure why it is skipping that ticket? Or can someone tell me how to modify the ticket to specifically include Ticket 4284 to this All Tickets report...where and what would I add?
SELECT HD_TICKET.CREATED, S.FULL_NAME AS SUBMITTER_NAME, HD_TICKET.ID, HD_TICKET.TIME_CLOSED, HD_TICKET.TIME_OPENED, HD_TICKET.TITLE, O.FULL_NAME AS OWNER_NAME, HD_TICKET.APPROVAL, (LEFT(GROUP_CONCAT(DISTINCT COMMENT SEPARATOR '
'),255)) AS SHORT_COMMENT, HD_STATUS.NAME AS STATUS FROM HD_TICKET LEFT JOIN USER S ON (S.ID = HD_TICKET.SUBMITTER_ID) LEFT JOIN USER O ON (O.ID = HD_TICKET.OWNER_ID) LEFT JOIN HD_TICKET_CHANGE ON (HD_TICKET_CHANGE.HD_TICKET_ID = HD_TICKET.ID) JOIN HD_STATUS ON (HD_STATUS.ID = HD_TICKET.HD_STATUS_ID) WHERE (HD_TICKET.HD_QUEUE_ID = 1) AND ((HD_TICKET.TIME_OPENED > '2015-10-16 23:59:59')) GROUP BY HD_TICKET.ID ORDER BY ID, TIME_CLOSED, TITLE
Answers (0)
Be the first to answer this question
If removing that you can see the missing tickets it means that the problem is that the tickets that you do not see do not satisfy that condition..
Regards,
Marco - StockTrader - StockTrader 8 years ago
You can do a ''dirty trick''
Try the following:
AND ((HD_TICKET.TIME_OPENED > '2015-10-16 23:59:59') OR HD_TICKET.ID = 4284)
if you need to add more tickets you can use something like that:
AND ((HD_TICKET.TIME_OPENED > '2015-10-16 23:59:59') OR HD_TICKET.ID IN (4284,...,...,..))
Kind regards,
Marco - StockTrader - StockTrader 8 years ago