/bundles/itninjaweb/img/Breadcrumb_cap_w.png
I'm trying to generate a report that will display all hours worked by service desk owners during a time specified, but only for a specific queue.   The canned report "Work Report last 31 days by person" works fine except I don't know how to make it specific to only one queue.  Obviously I know next to nothing about SQL because this is probably very easy.   Here's the code from that canned report, can please someone modify it to relate only to Queue_ID 24?  Any help is greatly appreciated!

select W.STOP as DATE, CONCAT(CAST(T.ID AS CHAR), " - ", T.TITLE) as TICKET, U.FULL_NAME, substring(W.NOTE,1,1200) as NOTE,
format((time_to_sec(timediff(stop, start)))/3600.0 + ADJUSTMENT_HOURS,2) as HOURS_WORKED
from (HD_WORK W, HD_TICKET T, USER U)
where W.HD_TICKET_ID = T.ID
  and isnull(W.VOIDED_BY)
  and W.USER_ID = U.ID
  and W.STOP > DATE_SUB(NOW(), INTERVAL 31 DAY)
order by U.FULL_NAME, TICKET, W.STOP

1 Comment   [ - ] Hide Comment

Comments

  • You are nearly there add

    and T.HD_QUEUE_ID = 24
    • Thank you, perfect! I attempted that but I left out the T. so it didn't work. I appreciate it.
Please log in to comment

There are no answers at this time
Answer this question or Comment on this question for clarity

Answers