SELECT cdtd.workorderid'RequestID',

td.TITLE 'Title',

longtodate(td.SCHEDULEDSTARTTIME) 'Scheduled Start Time',

longtodate(td.SCHEDULEDENDTIME) 'Scheduled End Time',

td.MODULE 'Module',std.STATUSNAME 'Status',

aauo.FIRST_NAME 'Assigned To',

aauc.FIRST_NAME 'Created By',

longtodate(td.ACTUALSTARTTIME) 'Actual Start Time',

longtodate(td.ACTUALENDTIME) 'Actual End Time',

td.DESCRIPTION 'Description',

td.COMMENTS 'Comments' FROM workordertotaskdetails cdtd

LEFT JOIN taskdetails td on cdtd.taskid=td.taskid LEFT JOIN SDUser sduo ON td.OWNERID=sduo.USERID LEFT JOIN AaaUser aauo ON sduo.USERID=aauo.USER_ID LEFT JOIN SDUser sduc ON td.OWNERID=sduc.USERID LEFT JOIN AaaUser aauc ON sduc.USERID=aauc.USER_ID LEFT JOIN StatusDefinition std ON td.STATUSID=std.STATUSID

order by 1

 

Thanks,

 

Mauricio