Report to show Hours for each Technician
I am looking to create or modify an excisting report that will show Department (Custom Field), Ticket, Date Work Entered, Technician Name, Hours Worked for last x amount of days. We currently have a report "Work Report last 31 days by person" which works ok, but is lacking the Department field.
I do not know SQL and not sure how to modify to obtain Department field or change to reflect the last 14 days or so.
Work Report last 31 days by person
Description: Reports all people who logged work during the last 31 days. Display by person, then ticket and time.
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 W.USER_ID = U.ID
and W.STOP > DATE_SUB(NOW(), INTERVAL 31 DAY)
order by U.FULL_NAME, TICKET, W.STOP
I would like to display this by Department, Person / Technician, Date and Time.
It should also include all Queues
Other info if needed. We are using K1000 6.2
Any help would be greatly appreciated.