Request Management - notes added by the technicians
This report gives an overview of all notes added by the technician.
SELECT wo.WORKORDERID "Request ID", note.NOTESTEXT "Notes", longtodate(notesdate) "Note Added date", aaauser.first_name "Note Added By" FROM WorkOrder wo LEFT JOIN Notes note ON wo.WORKORDERID=note.WORKORDERID LEFT JOIN aaauser ON note.userid=aaauser.user_id WHERE wo.CREATEDTIME >= <from_thisweek> AND wo.CREATEDTIME <= <to_thisweek>
Click this link to navigate to the next report.