Report for No Notes in 72 Hours
Hello, is it possible to create a query report that looks at incidents/requests that have not had a note added over the past 72 hours?
I found this:
SELECT wo.WORKORDERID "Request ID", wo.title 'subject',notes.NotesText "Request Notes" FROM WorkOrder wo left join notes on notes.workorderid=wo.workorderid WHERE wo.isparent=1
but it only shows me request id, subject and notes. Any way to show only those without notes in the last 72 hours?
Thanks