/build/static/layout/Breadcrumb_cap_w.png
10/09/2018 188 views
I am trying to run a report to show the total ticket count  for a specific time frame.  I just need a count for a psecific date range... no other data.  What would the SQL for this look like?
0 Comments   [ + ] Show comments

Comments


All Answers

0
This is for tickets created between October 1 and October 9, inclusive, and specific to one queue.


SELECT
  COUNT(ID)

FROM HD_TICKET

WHERE
  DATE(CREATED) BETWEEN '2018-10-01' AND '2018-10-09'
  AND HD_QUEUE_ID = 5
Answered 10/09/2018 by: ondrar
Second Degree Brown Belt