Ticket Report for a specific month
Hi I am trying to create a report of all tickets that were sent in a a specific month. I would like to have this report so we can edit the month and year and grab a report from what ever time period we need. I am having trouble creating the filter that does that. My reports come back empty. I cant tell what im doing wrong after reading some posts about the same issue. Below is the SLQ code of my report. The example that is there I am trying to get tickets created in January 2019. I made this using the wizard but it is still blank, I tried changing > to >= and < to <= but still nothing. Am I missing something obvious? Any help is very appreciated.
SELECT HD_TICKET.TITLE, CTEXT.NAME AS CATEGORY_TEXT, HD_TICKET.RESOLUTION, S.FULL_NAME AS SUBMITTER_NAME, O.FULL_NAME AS OWNER_NAME, IF(HD_TICKET.HD_USE_PROCESS_STATUS and HD_TICKET.IS_PARENT, HD_SERVICE_STATUS.NAME, HD_STATUS.NAME) AS STATUS_NAME FROM HD_TICKET LEFT JOIN HD_CATEGORY CTEXT ON (CTEXT.ID = HD_TICKET.HD_CATEGORY_ID)
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_SERVICE_STATUS ON HD_TICKET.HD_USE_PROCESS_STATUS and HD_TICKET.HD_SERVICE_STATUS_ID and HD_SERVICE_STATUS.ID = HD_TICKET.HD_SERVICE_STATUS_ID JOIN HD_STATUS ON (HD_STATUS.ID = HD_TICKET.HD_STATUS_ID)
WHERE (HD_TICKET.HD_QUEUE_ID = 1) AND ((HD_TICKET.CREATED > '2019-01-01 00:00:00') AND (HD_TICKET.CREATED < '2019-01-31 23:59:59')) ORDER BY TITLE
Answers (1)
I like using the between operator:
DATE(HD_TICKET.CREATED) BETWEEN "2020-01-01" AND "2020-01-31"
You could also do something like:
MONTH(HD_TICKET.CREATED) = 1 and YEAR(HD_TICKET.CREATED) = 2020
