Request Management - to get the list of shared requests

Shared request - returns the list of shared requests.

To make any changes to this query, refer to this post.

SELECT wo.WORKORDERID AS "Request ID",
       wo.TITLE AS "Subject",
       aau.FIRST_NAME AS "Requester",
       qd.QUEUENAME AS "Group",
       ti.FIRST_NAME AS "Technician",
       std.STATUSNAME AS "Request Status",
       sa.first_name "Shared to technician" FROM WorkOrder wo
LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID
LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID
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 StatusDefinition std ON wos.STATUSID=std.STATUSID
LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID
LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID
LEFT JOIN WO_SHARE_LIST wsl ON wo.workorderid=wsl.workorderid
LEFT JOIN TECHNICIAN_SHARE_LIST tsl ON wsl.shareid=tsl.shareid
LEFT JOIN aaauser sa ON tsl.techid=sa.user_id
WHERE (wo.ISPARENT='1') and wo.CREATEDTIME >= <from_thisweek> and wo.CREATEDTIME <= <to_thisweek>