Version : 14305

DB : MSSQL / POSTGRES

OUTPUT:

Query:

select Longtodate(wosh.SHARED_TIME) "Shared Date",
wo.workorderid "Request ID",
aaush.FIRST_NAME "Who Shared",
aau.FIRST_NAME "Technician Shared To",
wosh_comment.TECHNICIAN_COMMENTS "Comments" from WorkOrder wo
INNER Join wo_share_list wosh on wo.workorderid = wosh.WORKORDERID
INNER Join technician_share_list tech_list on wosh.shareid = tech_list.shareid
Left Join sdUser sd on tech_list.techid = sd.userid
Left Join aaauser aau on sd.userid = aau.USER_ID
Left Join sdUser sdsh on wosh.SHARED_BY = sdsh.userid
Left Join aaauser aaush on sdsh.userid = aaush.USER_ID
Left Join wo_share_comments wosh_comment on wo.workorderid = wosh_comment.WORKORDERID where wo.isparent = 1