Hi,

I'm trying to create a query report to display:

Request ID

Request Status

Requester

Dept

Subject

Technician

Description

Created Time

Notes (All Notes if possible, if not latest)

I've managed to find a report searching the forum, which works for the Notes field but I'm struggling to add all the fields I require.

SELECT wo.WORKORDERID "Request ID",ti.FIRST_NAME "Support Rep",wo.TITLE "Subject",note.notestext "Notes" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN Notes note on wo.workorderid=note.workorderid WHERE (wo.CREATEDTIME >= unix_timestamp(' 2016-08-01 00:00:00')*1000) AND (wo.CREATEDTIME <= unix_timestamp(' 2016-08-31 23:59:59')*1000)

Please could somebody help me out?

Thanks